M Mary Jul 16, 2008 #1 I am doing a vlookup on a worksheet that shows a blank date in the field yet on the vlookup it shows as 1/0/00. How can I correct this.
I am doing a vlookup on a worksheet that shows a blank date in the field yet on the vlookup it shows as 1/0/00. How can I correct this.
T T. Valko Jul 16, 2008 #2 You seem to have the formula cell formatted as DATE so I'm assuming that you're expecting a date result and 0 is not a possible result of the formula. Try something like this: =IF(your_vlookup_formula_here=0,"",your_vlookup_formula_here)
You seem to have the formula cell formatted as DATE so I'm assuming that you're expecting a date result and 0 is not a possible result of the formula. Try something like this: =IF(your_vlookup_formula_here=0,"",your_vlookup_formula_here)
G Gord Dibben Jul 17, 2008 #3 Trap for it in your formula =IF(VLOOKUP(G1,$A$1:$F$31,2,FALSE)="","",(VLOOKUP(G1,$A$1:$F$31,2,FALSE))) Gord Dibben MS Excel MVP
Trap for it in your formula =IF(VLOOKUP(G1,$A$1:$F$31,2,FALSE)="","",(VLOOKUP(G1,$A$1:$F$31,2,FALSE))) Gord Dibben MS Excel MVP
