VLOOKUP

P

PAL

I am using vlookup with the following formula:

=VLOOKUP($A2,PROTOCOL,12,FALSE)

Column 12 is a date (01-jan-08). When the value in 12 is blank, I get
"0-jan-00" returned. How do I tweak to keep blank.

Thanks
 
G

Gord Dibben

=IF(VLOOKUP($A2,PROTOCOL,12,FALSE)="","",VLOOKUP($A2,PROTOCOL,12,FALSE))


Gord Dibben MS Excel MVP
 
Top