Find a group of names in a long list
 

Okay, I help score a racing series. There are 200 people in the series and I
have their names in an Excel spreadsheet. After every race I have to go
through the results (typically 200 to 600 names) and find anyone who is
signed up for the series. Usually there are about 70 people in the series at
each race. There is nothing in the race results to indicate they are in the
series besides their names.
I've been doing this manually, but wondered if I could copy/paste the list
of names from the individual race results and then have Excel automatically
pull out the names which match from my series roster.
Is this possible with excel?

Find a group of names in a long list
 

It sound like you need to use a VLOOKUP or HLOOKUP. Without more details
about the data you;re trying to get out, or what your sheet looks like, I'd
suggest looking at the excel helpfile on these 2 functions.

HTH.

"Carl_Monday" wrote:

Okay, I help score a racing series. There are 200 people in the series and I
have their names in an Excel spreadsheet. After every race I have to go
through the results (typically 200 to 600 names) and find anyone who is
signed up for the series. Usually there are about 70 people in the series at
each race. There is nothing in the race results to indicate they are in the
series besides their names.
I've been doing this manually, but wondered if I could copy/paste the list
of names from the individual race results and then have Excel automatically
pull out the names which match from my series roster.
Is this possible with excel?