ExcelBanter - VLOOKUP FUNCTION

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

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

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

Gavin

VLOOKUP FUNCTION

I have the following formula:

=IF($L$2="","",VLOOKUP($L$2,Database,37,0))

if the relevent cell is "blank" it returns a value of "0". I would like it
to return a value of "blank".

Thank you for any help in advance.

Dave Peterson

VLOOKUP FUNCTION

Just check to see if that cell is empty:

=IF($L$2="","",
if(VLOOKUP($L$2,Database,37,0)="","",VLOOKUP($L$2, Database,37,0)))

Gavin wrote:

I have the following formula:

=IF($L$2="","",VLOOKUP($L$2,Database,37,0))

if the relevent cell is "blank" it returns a value of "0". I would like it
to return a value of "blank".

Thank you for any help in advance.

--

Dave Peterson

Teethless mama

VLOOKUP FUNCTION

=IF($L$2="","",IF(VLOOKUP($L$2,Database,37,0)=0,"" ,VLOOKUP($L$2,Database,37,0)))

"Gavin" wrote:

I have the following formula:

=IF($L$2="","",VLOOKUP($L$2,Database,37,0))

if the relevent cell is "blank" it returns a value of "0". I would like it
to return a value of "blank".

Thank you for any help in advance.

All times are GMT +1. The time now is 12:47 PM.