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