| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Reconciling two lists
I am using vlookup function to reconcile two long lists of data. The issue I
am having is when one of the values does not find a match, I get an error. I would like it to bring back a zero rather than #N/A when a match is not found. What can I do? -- Stefan |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Reconciling two lists
Try this:
=IF(ISNA(your_formula),0,your_formula) Hope this helps. Pete On Dec 28, 4:14*pm, Stefan wrote: I am using vlookup function to reconcile two long lists of data. The issue I am having is when one of the values does not find a match, I get an error. I would like it to bring back a zero rather than #N/A when a match is not found. What can I do? -- Stefan |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Reconciling two lists
=if(isna(yourvlookupformula),0,yourvlookupformula)
If you're using xl2007, take a look at: =iferror() in excel's help. Stefan wrote: I am using vlookup function to reconcile two long lists of data. The issue I am having is when one of the values does not find a match, I get an error. I would like it to bring back a zero rather than #N/A when a match is not found. What can I do? -- Stefan -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| creating a reconciling list of items not matched between two files | Excel Worksheet Functions | |||
| LISTS- adding info without repeat to other lists | Excel Discussion (Misc queries) | |||
| Multiple lists with repeated values for dependet drop down lists | Excel Worksheet Functions | |||
| Reconciling Data Ranges | Excel Discussion (Misc queries) | |||
| lists from other lists in excel | Excel Worksheet Functions | |||
Hybrid Mode
