This has to be simple but......

[Fullam]

Sorry I suspect this is a very simple question but I am afraid its
stumped me

I have used a VLOOkUP on a set of dates. When a cell in the range I am
looking up is blank Excel is putting in the date of 00/01/1900 which in
turn is reeking havoc with a chart I am building.

How do I change the furmula or format the cell so that LOOKUP shows a
blank cell when the cell it is looking up is blank rather than this
meaningless date.

 

[Bob Umlas, Excel MVP]

=IF(VLOOKUP(...)=0,"",VLOOKUP(...))
Bob Umlas
Excel MVP

 

[Fullam]

Thanks Bob, very kind of you and it works perfectly - cheers

 

[BlueDaze]

Another way of doing it:

=IF(isblank(VLOOKUP(...))=true,"",VLOOKUP(...))