View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
papou[_2_] papou[_2_] is offline
external usenet poster
 
Posts: 112
Default Finding the Row number based on contents of a cell

Chris
MATCH does NOT return a cell reference.
It returns the position of the criteria found.

HTH
Cordially
Pascal

"Chris Youlden" a écrit dans le message de news:
...


Thanks to both of you. I didn't realise MATCH would return the cell
reference.

regards

Chris