Pull Members' Race Times from a Database?

[JTG]

Please help:

Sheet 1 is a spreadsheet with 1/2 marathon race results. Column A has
all the names (Last and first in the same cell, sorted alphabetically
by last name). Column K has the finishing times.

Sheet 2 is a list of our club members names. Again, last and first
names in the same cell, sorted alphabetically.

I am trying to use VLOOKUP to pull any members' finishing times from
sheet 1. However it is not working correctly. Times appear for those
who did not run the race (I want NA to show) and some members who did
run the race have the wrong time next to them. Trying FALSE or 0 does
not seem to help.

What am I doing wrong? Am I using the wrong formula?

Thanks in advance,

-Ted

 

[CLR]

VLOOKUP could very well be the correct function to use to get the results
you seek........post the exact formula you're using and we'll have a look at
it.........

Vaya con Dios,
Chuck, CABGx3

 

[JTG]

=VLOOKUP(A2,Sheet1!A$1:M$981,11)

And again, placing ,FALSE or ,0 after 11 does not seem to help pull
the correct result.

Thanks for your help.

 

[JTG]

I figured out the problem. The results database had an extra space
between the last and first names and another one at the end of the
first name. As a result the names were not matching exactly. After
cleaning up the database with =TRIM all works fine now.

Thanks for your time.

 

[CLR]

Glad you got it working...........I know the frustration, having been there
a few times........

Vaya con Dios,
Chuck, CABGx3