View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Wind54Surfer Wind54Surfer is offline
external usenet poster
 
Posts: 16
Default 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.