| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove #n/a in vlookup to sum results
Excel 2007 - I have vlookup formulas in cell c2 and d2. In c2 the result of
the vlookup is 5 and in d2 the results of the vlookup is #n/a. I then need to sum cell c2 and d2 but I cannot since d2 contains #n/a. How can I remove/change this so I can sum these two cells together? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum the results of a vlookup | Excel Worksheet Functions | |||
| Remove Negative Signs from Formula Results | Excel Worksheet Functions | |||
| Sum results of VLOOKUP | Excel Worksheet Functions | |||
| Vlookup with two results | Excel Discussion (Misc queries) | |||
| to sum up all value results from VLOOKUP | Excel Worksheet Functions | |||
Threaded Mode
