VLOOKUP FUNCTION

[Guest]

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]

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

 

[Guest]

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