# Lookup a blank cell in a Lookup table and return a figure.

1. ## Lookup a blank cell in a Lookup table and return a figure.

I am using a lookup table to lookup codes that then give a dollar value within my spreadsheet, using the following formula =IF(B5=0,"",(VLOOKUP(B5,\$A\$236:\$B\$250,2,FALSE))), however I have one code in the lookup table that is blank but still requires a dollar value to be added to my spreadsheet. At the moment the cell is returning a blank value instead of the \$30 it should, Any ideas?

A236 B236
Lookup Code Dollar Value

TRAVEL \$900.00
{BLANK} \$30.00  Register To Reply

2. ## Re: Lookup a blank cell in a Lookup table and return a figure.

Because when you refer a formula which is really blank then then blank cell is considered as 0.

Just press = and refer on a blank cell and give enter surely it will result 0.

=IF(B5=0,"",(VLOOKUP(B5,\$A\$236:\$B\$250,2,FALSE)))

So in your above formula B5=0 is matching and its resulting blank as result.  Register To Reply

3. ## Re: Lookup a blank cell in a Lookup table and return a figure.

Sorry, I'm not understanding what you mean!  Register To Reply