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/217039-vlookup.html)

GEM

Vlookup.

If a cell is blank where the vlookup function is searching, the answer it's
returning is "0"

How can I have a blank cell instead of a 0??

Bob Phillips[_3_]

Vlookup.

=IF(vlookup_formula="","",vlookup_formula)

--
__________________________________
HTH

Bob

"GEM" wrote in message
...
If a cell is blank where the vlookup function is searching, the answer
it's
returning is "0"

How can I have a blank cell instead of a 0??

Mike H

Vlookup.

Hi,

Try this

=IF(VLOOKUP(C1,A1:B20,2,FALSE)="","",VLOOKUP(C1,A1 :B20,2,FALSE))

This will still return NA# if the lookup values isn't found.

Mike

"GEM" wrote:

If a cell is blank where the vlookup function is searching, the answer it's
returning is "0"

How can I have a blank cell instead of a 0??

GEM

Vlookup.

Thank you!!

"Bob Phillips" wrote:

=IF(vlookup_formula="","",vlookup_formula)

--
__________________________________
HTH

Bob

"GEM" wrote in message
...
If a cell is blank where the vlookup function is searching, the answer
it's
returning is "0"

How can I have a blank cell instead of a 0??

All times are GMT +1. The time now is 08:32 AM.