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