Not sure if this is a vlookup question or not. I've got a list of all members
of our sports club. And I have a list of all members who took part in a race.
I want to add a column to the list of all members to show who took part in
the race. If they took part, I would like "Attended" to show in this new
column. Any way of doing this??

Say the list of all members runs from A1 to A100 and the list of racers from
E1 to E10. You could enter this formula in B1 and copy it down to B100 to
get what you want:

=IF(ISERROR(MATCH(A1,$E$1:$E$10,0)),"","Attended")

The Match function is not case sensitive but spelling, spaces, punctuation,
etc. has to be identical.

--
Jim Rech
Excel MVP
"Lee" wrote in message
...
Not sure if this is a vlookup question or not. I've got a list of all
members
of our sports club. And I have a list of all members who took part in a
race.
I want to add a column to the list of all members to show who took part in
the race. If they took part, I would like "Attended" to show in this new
column. Any way of doing this??