| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum Result of lookup in excel 2007
Hi using excel 2007 looking up values and need to sum the results
lookup function =IFERROR(LOOKUP(A3,{7,8,9,13,1330,1430,15,2130,224 5},{"8","8","6","8","9","8","8","8","8"}),"0"). this returns great results and what I need. If the value is not found returns 0 and not #N/A if the "iferror" part is not used. The results are in another column. When I sum the results I get 0.00 changing the format of the cell has no effect. I hope someone can help as this has been driving me crazy and i know it will be very simple. help please |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 - change size of text as a result of conditional format | Excel Discussion (Misc queries) | |||
| Excel 2007 Lookup | Excel Worksheet Functions | |||
| why result 77.1 * 850 shown 100000 in excel 2007? | Excel Discussion (Misc queries) | |||
| Lookup for more than one result | Excel Discussion (Misc queries) | |||
| Join 2 Lists - Lookup value in 1 list & use result in 2nd lookup | Excel Worksheet Functions | |||
Threaded Mode
