Pull Members' Race Times from a Database?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JTG - 07 Apr 2007 01:58 GMT

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

Reply to this Message

CLR - 07 Apr 2007 02:07 GMT

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

> Please help:
>
[quoted text clipped - 16 lines]
>
> -Ted

Reply to this Message

JTG - 07 Apr 2007 11:49 GMT

=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.

>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
[quoted text clipped - 23 lines]
>>
>> -Ted

Reply to this Message

JTG - 07 Apr 2007 15:40 GMT

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.

>=VLOOKUP(A2,Sheet1!A$1:M$981,11)
>
[quoted text clipped - 30 lines]
>>>
>>> -Ted

Reply to this Message

CLR - 08 Apr 2007 02:24 GMT

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

Vaya con Dios,
Chuck, CABGx3

> 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
[quoted text clipped - 37 lines]
> >>>
> >>> -Ted

Reply to this Message