| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup resulting in #N/A
I understand why I am getting this message I just don't know how to hide that
result on my spreadsheet. The problem is I have a column of vlookup resulte that I am trying to add and I can't becuase that results in a #N/A also....help? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
vlookup resulting in #N/A
=IF(ISNA(Your_Formula),"",Your_Formula)
Regards Ken.................... "bubbles" wrote in message ... I understand why I am getting this message I just don't know how to hide that result on my spreadsheet. The problem is I have a column of vlookup resulte that I am trying to add and I can't becuase that results in a #N/A also....help? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
vlookup resulting in #N/A
You could return a 0 or "" (depending on how you're adding the value).
if you're using the + operation (like =A1+C1) =if(isna(vlookup(...)),0,vlookup(...)) or if you're using =sum() (like(=sum(a:a)) =if(isna(vlookup(...)),0,vlookup(...)) bubbles wrote: I understand why I am getting this message I just don't know how to hide that result on my spreadsheet. The problem is I have a column of vlookup resulte that I am trying to add and I can't becuase that results in a #N/A also....help? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculations resulting in #DIV/0! | Excel Worksheet Functions | |||
| Formula to convert resulting #N/A to 0 | Excel Worksheet Functions | |||
| Formula resulting in 0 | Excel Discussion (Misc queries) | |||
| sumproduct resulting in #N/A | Excel Worksheet Functions | |||
| VLookup resulting in a blank cell... | Excel Worksheet Functions | |||
Hybrid Mode
