| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#N/A Error Reference
I currently have a look up table and use the following formula:
=VLOOKUP(C2&D2&E2,All_prices!$A$2:$H$33,8,FALSE) However, if any of the attributes in columns C D and E do not match, then #N/A is returned (in this case Cell G2). This is causing a problem when I try to total colum G. Is there a way of returning 0 instead of #N/A? I hope this makes sense... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deleted row reference error | Excel Discussion (Misc queries) | |||
| Circular Reference Error Even Though There Is No C.R. | Excel Worksheet Functions | |||
| Circular reference error | Excel Discussion (Misc queries) | |||
| reference #value error | Excel Worksheet Functions | |||
| Maddening reference error | New Users to Excel | |||
Threaded Mode
