Hello Chris
As mentionned by chelsea, you may use the MATCH function but this will work
if your data starts at line 1.
If it doesn't, you can try this formula (amend references and criteria
accordingly):
=IF(MATCH("Criteria",A5:A13,0)<ROW(A5),MATCH("Crit eria",A5:A13,0)+(ROW(A5)-1),MATCH("Criteria",A5:A13,0))

But I am sure someone will have a better looking formula ;-)

HTH
Cordially
Pascal

"Chris Youlden" a écrit dans le message de news:
...
I would like to find the row number of a cell based on it contents. In
other words, search a column for a particular value and then find the row
number.

Is there an easy way to do this?

TIA

Chris