Thank you so much..... it did work. Funny - I teach Excel and am unfamiliar
with the way this worked. Where did you get info on this - or do you do some
programming? Seems that it's fairly common to look up something that has to
have 2 fields matching.... surprised there isn't an "advanced lookup" in the
tools.....

"Fran" wrote:

Simple problem - hard to figure. (This report is imported with information
missing - it only contains a first initial instead of the name - AND the
initial could be wrong - so I consider the column empty) Column A has last
name, Column B has first initial, Column F has birthdate.

I am trying to match the Last Name (Column A) and Birthdate (Column F) to
give me the First name......(Column B)

I created a 'lookup file" on sheet 2 showing last names AND first names and
Birthdate. I know that VLookup with give me last name and show the First
name... but there are hundreds of names. I need to Match 2 criterial - the
last name with the Birthdate to give me the first name. Would really
appreciate help. Working on this for tomorrow at work.