How to match to any value
 

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.

How to match to any value
 

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---


--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Wind54Surfer" wrote:

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.

How to match to any value
 

Thanks for your help.

I end it up doing something different.

"ryguy7272" wrote:

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---


--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Wind54Surfer" wrote:

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.