ExcelBanter - VLOOKUP

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - VLOOKUP (https://www.excelbanter.com/excel-worksheet-functions/174452-vlookup.html)

PAL

VLOOKUP

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

Gord Dibben

VLOOKUP

=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

PAL

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

All times are GMT +1. The time now is 03:21 PM.