Find Cell

[ianripping]

How do I find the row number of a cell with a certain criteria

eg.

In Col a I have a list of names

I want a function to search col A for a certain name and return its ro
number

 

[Frank Kabel]

Hi
try
=MATCH("name to find",A1:A1000,0)

 

[JE McGimpsey]

One way:

=MATCH(Name, A:A, FALSE)

or, if the name may not exist in the column:

=IF(ISNA(MATCH(Name, A:A, FALSE)), "", MATCH(Name, A:A, FALSE))

 

[Guest]

It worked. Thank you!

-----Original Message-----
Hi
try
=MATCH("name to find",A1:A1000,0)

--
Regards
Frank Kabel
Frankfurt, Germany

.