VLOOKUP
Holy Smokes. Thanks.
"Gord Dibben" wrote:
=IF(VLOOKUP($A2,PROTOCOL,12,FALSE)="","",VLOOKUP($ A2,PROTOCOL,12,FALSE))
Gord Dibben MS Excel MVP
On Fri, 25 Jan 2008 09:59:01 -0800, PAL wrote:
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
|