# 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

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.

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

Sorry, I'm not understanding what you mean!

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1