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