blank date shows up as s 1/0/00

M

Mary

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

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Countdown macro - display settings 2
How to use/create code in MS Word to calculate age? 0
Combing a V Lookup result with ("00"&A2)*1 in same formula 4
Doughnut Chart linked with the slicer in the pivot table 0
Outlook 365 overriding formatting choices 0
Dcount -Date Criteria - Won´t find it - 0
Format Cell 8
VBA Coding Help for Beginner 0

Top