| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup formula
I am doing a Vlookup, when it comes to one of my lookups where there is no colum index for that lookup value it returns #N/A. How can I get it to return, when there is no information, a 0? -- dculver |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Vlookup formula
Hi
Check you PC time - I think it's a bit out! Try this format: =IF(ISERROR(yourVLOOKUP),0,yourVLOOKUP) Hope this helps. Andy. "dculver" wrote in message ... I am doing a Vlookup, when it comes to one of my lookups where there is no colum index for that lookup value it returns #N/A. How can I get it to return, when there is no information, a 0? -- dculver |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLOOKUP Formula | Excel Discussion (Misc queries) | |||
| VLOOKUP result is not showing up - only the formula | Excel Worksheet Functions | |||
| IF / VLOOKUP formula won't work until saved | Excel Worksheet Functions | |||
| What can I add to a vlookup formula to give me a 0 not #n/a | Excel Worksheet Functions | |||
| IF & VLOOKUP FORMULA | Excel Worksheet Functions | |||
Linear Mode
