Vlookup returns 1/0/1900?

[CSPENCER]

I have a formula =VLOOKUP(C6,A1:C8,3,FALSE) which returns 1/9/1900 if the cell is blank. Which I think is because it returns a 0 value and the cell is formatted for a date. So I tried =IFERROR(VLOOKUP(C6,A1:C8,3,FALSE),"") hoping this would return a blank instead. No such luck. Please help.

Thanks, Curt

[oeldere]

You can try this one (untested).

=if(VLOOKUP(C6,A1:C8,3,FALSE)=1/9/1900,"",VLOOKUP(C6,A1:C8,3,FALSE))

[ConneXionLost]

Try:

Please Login or Register  to view this content.

Otherwise, change the cell format.

[Tony Valko]

If the value being returned is a number (or date):

=IFERROR(1/(1/VLOOKUP(C6,A1:C8,3,0)),"")

Seems kind of odd that the lookup value is within the table array result column?

[martindwilson]

if the result is always a date or 0/blank
=IFERROR(1/(1/VLOOKUP(C6,A1:C8,3,FALSE)),"")
snap!

[daddylonglegs]

If you custom format the result cell as follows:

m/d/yyyy;;

Then the two semi-colons at the end of that ensure that zeroes are displayed as blanks