Vlookup plus

[Vicky]

I have two tables, in table A I have a list of locations and a estimated ship
date. In table B I have locations and the actual ship date. Table B is a
subset of table A, in other words, not all the locations ship each time I run
this. Also, some of the locations show without a date. They are blank.

I want to compare the 2 dates and see if they are the same. I did a vlookup
but the issue is becuase they are dates I am getting some odd results, If the
date is blank, I get a "zero" and if the location from Table A is not in
Table B I get #N/A. For other dates I get the 5 digit date number (39222). I
then convert the format to "date" formatting, which fixes the 5 digit date
problem but now the dates that are blank show up at 1/0/1900.

I thought I could nest an IF function around the Vlookup but I must be doing
it incorrectly.
Any thoughts?

Thanks!

 

[T. Valko]

So, what you're wanting to do is get rid of the #N/As and returns of
1/0/1900?

One way:

=IF(ISNA(VLOOKUP(.....)),"",IF(VLOOKUP(.....)=0,"",VLOOKUP(.....)))