How to match to any value

[Wind54Surfer]

I am trying to use the following:

=MATCH(1,INDEX(B:B,E2+1):$B$65536,)+E2

This only works with the number 1

but need to match any value, like: 7, 51, 120, 1232

I try to use <>"" but don't have the knowledge.

Any help really appreciated.

 

[ryguy7272]

What are you trying to do? I'm going to make a WAG here...
Hope this is it (or i totally missed the boat on this one):
=MATCH(E2,B:B,0)

Look in Help for =match()
Some good examples there.

HTH,
Ryan---

 

[Wind54Surfer]

Thanks for your help.

I end it up doing something different.