Home |
Search |
Today's Posts |
#1
|
|||
|
|||
need look up table to return blank
Hello:
I have lookup table but I have cells that have zeros. What can I insert in the lookup table so when a zero is looked up and matched It will be a blank cell. I have tried placing a zero and then a blank, but it returns a zero. Thanks, Zetastrat |
#2
|
|||
|
|||
Hi!
Instead of "padding" the lookup table just write your formula to check for zero. Something like this: =IF(VLOOKUP(A1,B:D,3,0)=0,"",VLOOKUP(A1,B:D,3,0)) Biff -----Original Message----- Hello: I have lookup table but I have cells that have zeros. What can I insert in the lookup table so when a zero is looked up and matched It will be a blank cell. I have tried placing a zero and then a blank, but it returns a zero. Thanks, Zetastrat . |
#3
|
|||
|
|||
zetatstrat Wrote: Hello: I have lookup table but I have cells that have zeros. What can I insert in the lookup table so when a zero is looked up and matched It will be a blank cell. I have tried placing a zero and then a blank, but it returns a zero. Thanks, Zetastrat If the lookup table is sorted on its first column, try the recipe described in my contrib in: http://www.mrexcel.com/board2/viewtopic.php?t=116943 -- Aladin Akyurek ------------------------------------------------------------------------ Aladin Akyurek's Profile: http://www.excelforum.com/member.php...fo&userid=4165 View this thread: http://www.excelforum.com/showthread...hreadid=319973 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Zero Value | Excel Discussion (Misc queries) | |||
table | Excel Discussion (Misc queries) | |||
changing proportion of chart and data table | Charts and Charting in Excel | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
In excel and a pivot table - how can I stop it displaying (blank). | Excel Discussion (Misc queries) |