You could lookup on a combination of last and first names, like

=INDEX(O2:O100,MATCH(A1&B1,M2:M100&N2:N100,0))

which is an array formula so commit with Ctrl-Shift-Enter

--

HTH

RP
(remove nothere from the email address if mailing direct)


"James" wrote in message
...
Hi Everyone!

I'm using VLOOKUP to match last names. The problem i'm having is multiple
people with the same name. VLOOKUP returns the fist match, what are some
suggestions and ideas so that i can get a list to choose from?
Also, is there a way to do wildcard searches in excel in a VLOOKUP or does
it absolutely have to be an exact match?

any ideas?

TIA

James