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
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.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Sorry, I'm not understanding what you mean!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks