Help with MATCH function?

[travismcelroy]

I have a worksheet with 3 columns (last name, first name, date passed test). I have another worksheet (from another source) with the same information. Where the last and first names BOTH match from one sheet to the other, I want to post the date passed from the second worksheet to the first. I already figured out VLOOKUP for the last name (and used IF(ISERROR) to put "NONE" if Sheet1.LastName is not in Sheet2), but now I have a problem when I have the same last name and different first name, trying to pull the right data for the right name.

Any help is much appreciated.

Thanks,
-Trav

 

[Aladin Akyurek]

=INDEX(DateRange,MATCH(1,IF(LastNameRange=LastName,IF(FirstNameRange=FirstName,1)),0))

which must be confirmed with control+shift+enter, not just with enter.