VLOOKUP FUNCTION

G

Gavin

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.
 
D

Dave Peterson

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)))
 
T

Teethless mama

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