| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP - columnar sheet with multiple matches - need to return a
I have a huge spreadhset (and a deadline!) that VLOOKUP will find several
matches for the lookup_value. Each may have a diferent value at the range_lookup. I need the formula to return a sum of all values. Please help me figure out how to do it! Thanks very much! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need formulas to return multiple data matches | Excel Discussion (Misc queries) | |||
| Is there any way to use HLOOKUP in an array formula to return multiple matches? | Excel Worksheet Functions | |||
| How do I use lookup to return multiple matches and sum them? | Excel Discussion (Misc queries) | |||
| Vlookup to return the sum of multiple matches | Excel Discussion (Misc queries) | |||
| Can vlookup return multiple matches in a single cell? | Excel Discussion (Misc queries) | |||
Threaded Mode
