Thread: find Row
View Single Post
  #3   Report Post  
Bob Phillips
 
Posts: n/a
Default


"Stefi" wrote in message
...
MATCH function returns row number!


No, it returns the index into the data. This could be the row number IF it
is vertical data, but may not (MATCH("123",A100:A110,0 will never be between
100 and 110).