lookup row number

[Michael]

Hi,
can you tell me how to lookup the row number of a name in a list.

EG say I have a list of names as below:

Andrew
Mike
Steve
Ian
Paul

I would normally just add a column with the row numbers and then lookup the
row number in the second column but is it possible to do without adding the
extra column by using the row formula someohow?

Thanks

 

[Jacob Skaria]

Hi Michael

Try the below..
=MATCH("Mike",A:A,0)

 

[Fred Smith]

Match will give you the row number, as in:

=MATCH("Andrew",A1:A5,0)

Regards,
Fred

 

[Michael]

Excellent, thanks

Hi Michael

Try the below..
=MATCH("Mike",A:A,0)