Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
look up tables and getting rid of the #N/A
When you do not have information for a cell how do you get it to leave the
cell blank or return a zero as opposed to the #N/A |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
look up tables and getting rid of the #N/A
Typically, you would pre-test for the item to find....
Here are a couple ways: =IF(ISNUMBER(MATCH("find_me",A1:A10,0)),VLOOKUP("f ind_me",A1:C10,3,0),"") or =IF(COUNTIF("find_me",A1:A10),VLOOKUP("find_me",A1 :C10,3,0),"") Is that something you can work with? Regards, Ron Coderre Microsoft MVP (Excel) "smiley61799" wrote in message ... When you do not have information for a cell how do you get it to leave the cell blank or return a zero as opposed to the #N/A |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
look up tables and getting rid of the #N/A
In xl2003, you can use a formula like:
=if(isna(vlookup(...)),"",vlookup(...)) or =if(isna(vlookup(...)),0,vlookup(...)) In xl2007, you can use the =iferror() function. =iferror(vlookup(...),"") smiley61799 wrote: When you do not have information for a cell how do you get it to leave the cell blank or return a zero as opposed to the #N/A -- Dave Peterson |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
look up tables and getting rid of the #N/A
I am not good at this at all, novice at best. This is my current formula,
are you able to tell me how to alter my formula to yield a - or 0? I appreciate your help =VLOOKUP(F12:F45,Sheet3!G4:H51,2,FALSE) "Ron Coderre" wrote: Typically, you would pre-test for the item to find.... Here are a couple ways: =IF(ISNUMBER(MATCH("find_me",A1:A10,0)),VLOOKUP("f ind_me",A1:C10,3,0),"") or =IF(COUNTIF("find_me",A1:A10),VLOOKUP("find_me",A1 :C10,3,0),"") Is that something you can work with? Regards, Ron Coderre Microsoft MVP (Excel) "smiley61799" wrote in message ... When you do not have information for a cell how do you get it to leave the cell blank or return a zero as opposed to the #N/A |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Building pivot tables in Excel 2007 based on existing pivot tables? | Excel Discussion (Misc queries) | |||
Help with tables | Excel Discussion (Misc queries) | |||
Tables | Excel Discussion (Misc queries) | |||
Two new tables from one | Excel Discussion (Misc queries) | |||
Look up tables | Excel Discussion (Misc queries) |