Finding the Row number based on contents of a cell

C

Chris Youlden

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
 
C

chelsea

U can use the Match formula, for more detail u can get form the office help
..i.e. =match(a1,column,0)
Regars
Sebation.G
 
P

papou

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("Criteria",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
 
C

Chris Youlden

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

regards

Chris
 
P

papou

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

HTH
Cordially
Pascal
 
C

Chris Youlden

papou said:
Chris
MATCH does NOT return a cell reference.
It returns the position of the criteria found.
Click to expand...


Ah, yes, of course. As my data is only in one column I was fooled by that!

thanks

Chris
 
Top