Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Alternative to using 10 V-lookup formulas
I have table with sales data.
The user types in the classes they want to sum....they can type up to 10 classes. How can I avoid having to write a formula to sum ten V-lookups? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Returning an alternative value if lookup cannot be found in array | Excel Discussion (Misc queries) | |||
Get Cell Address From Lookup (Alternative to Lookup) | Excel Worksheet Functions | |||
lookup formulas dependent upon lookup formulas | Excel Worksheet Functions | |||
lookup formulas dependent upon lookup formulas | Excel Worksheet Functions | |||
Case specific LOOKUP alternative | Excel Discussion (Misc queries) |