| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Replacing #N/A response when obtained in Lookup function
When using Vlookup and there is no direct match the response is "#N/A",
telling me that there is no value in the lookup table. The problem is that I have to sum the results of the lookup function. Since some of the values are "#N/A" the sum of the column is "#N/A". How can I easily replace the "#N/A" with either text or a "0" so that the sum formula for the column produces an answer? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup Function Problem | Excel Discussion (Misc queries) | |||
| Lookup function w/Text and Year | Excel Worksheet Functions | |||
| Index table lookup anomaly | Excel Worksheet Functions | |||
| Excel Lookup Functions | Excel Worksheet Functions | |||
| double lookup, nest, or macro? | Excel Worksheet Functions | |||
Threaded Mode
