[Solved] Finding position of a match

[CaliRay]

I have a range of cells A10-C2000. All of the A column cells contain names, B column cells contain birth dates and C column cells contain a 7 digit ID number. All I need to do is find a match for a name I enter into cell F10 to verify the name is in the range and return either the cell number where the matching name is or the row containing that name.

An properly structured example formula and how it works would be appreciated. The examples I have read don't explain in detail how this example works. All I get is a 504 error.

Code: Select all

=MATCH($F$10;$A$11:$C2004; 0)-1

Thank you in advance for your help.

[Villeroy]

MATCH matches within a vector (one column or row), say column A:

Code: Select all

=MATCH($F$10 ; $A$11:$A$2004 ; 0)-1

[CaliRay]

Thanks for that. What's the correct function for what I need?

[RusselB]

To the best of my ability to tell, the MATCH function is the function you are looking for.
The reason you were getting that error, is that the MATCH function will only work with 1 row or 1 column.
In your original code you have 3 columns and 1,994 rows. I suspect that you want to keep the number of rows and change the range to be 1 column, as shown in Villeroy's reply.
It will return the matching row number, but if you want the actual cell address, then you're going to have to manually provide the column (and sheet, if necessary) identifier(s).