Karen

Yes, That is what VLOOKUP formulas do, extract information from the list. It
is like a policeman entering a car's registration into a database to find the
owner of that car.

The only thing to remember is that the list must be sorted by the Riders
number or the results may give an error. Put your cursor in the Numbers
column and click the A-Z Icon, or use the Data menu, Sort.

If you enter say 5001 by mistake when there are only 5000 entrants the
formula returns a blank cell (because that entrant does not exist).

Happy typing and best of luck

Peter

"excelneophyte" wrote:

Peter & M Kan --
Would the separate table created, when I type in the 5 riders coming towards
me, be able to magically replicate their names, hometimes, etc. into the
adjacent columns beside the numbers I just typed in so all 5 names are right
there together on one short list?

If that is what you are saying is possible, then I am on cloud nine. To
have to scroll through a list of over 5000 entrants at some of these events,
well you can imagine, using just the find button, I don't hit very high
percentages when it comes to calling out their names. I would love to be
able to recognize more, if not all, of the riders for the incredible effort
they put forth to raise money for this charity.