Vlookup Problems

I wonder if anyone can help me please with a Vlookup issue.

In the attached spreadsheet I have a Vlookup that returns a Date of Birth (from the Lookup sheet) based on a name selected in column A of sheet 1. The formula works fine but I have 2 issues which I don't know a fix to.

1. If the Name in column A of Sheet 1 is blank it returns #N\A in column B. I want it to return a blank cell.

2. If the person does not have a DOB entered in column B in the lookup sheet the formula returns a date of 00 January 1900, which is not correct. In instances where there is no date on the Lookup sheet against a person's name I want the formula to return a blank cell.

Could anyone help me resolve these two issues please?

Many thanks

try to use this one;

b2:

=IFERROR(INDEX(Lookup!$B$2:$B$6,MATCH(A2,look,0)),"")

Try this

Please Login or Register  to view this content.

Hope this helps

Excellent - that has fixed the #N\A problem, but I still have the issue with the wrong date of 00 January 1990 showing. Any ideas on a fix that will sort that one as well?

Thank you

This is your one solution for both problems :

Please Login or Register  to view this content.

Fantastic - that's done the trick. Thanks folks much appreciated.