VLOOKUP date without #N/A & 00/01/1900

[Gwill1983]

Hi all,

Really struggling with this one.

I am carrying out a vlookup against cells containing a date. I have established a way to do this to avoid returning #N/A for errors, but this then returns 00/01/1900 for cells containing no data. If I adjust the formula to get rid of the 00/01/1900 then the #N/A appear again!!

The formula I have for removing the #N/A is =IFERROR(VLOOKUP([@[PO Number]],Prev_Report,9,0),"")
The formula I have for removing the 00/01/1900 is =IF(VLOOKUP([@[PO Number]],Prev_Report,9,0)=0,"",VLOOKUP([@[PO Number]],Prev_Report,9,0))

Is there a way of combining these in some way to avoid both?

I only want it to return a result if there is a date in the resulting cell

 

[Gwill1983]

Oops should have said
If you format col 9 of the prev_report table as General what do you see?

It works! No idea what happened, but changed it to general then back to short date and it all appeared!

I suspect user error on my part somewhere along the line, but thanks very much for your help with the formula (and the clear formatting issue somewhere!)

 

[Fluff]

Glad it's working & thanks for the feedback.