| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel macro/function like VLOOKUP that sums eventual multiple matches
How can I create an Excel command (macro or function) that works like the
VLOOKUP function but sums eventual multiple matches? Example: Sheet1 - before execution: DOG | WHITE HOUSE | YELLOW CAT | GRAY Sheet2 - before execution: HOUSE | 300 DOG | 780 DOG | 200 BALL | 560 Sheet1 - AFTER execution: DOG | WHITE | 980 HOUSE | YELLOW | 300 CAT | GRAY | |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup Multiple Matches | Excel Worksheet Functions | |||
| VLOOKUP and multiple matches | Excel Discussion (Misc queries) | |||
| How do I get multiple matches when using the Vlookup function? | Excel Worksheet Functions | |||
| Multiple matches on VLOOKUP | Excel Worksheet Functions | |||
| Vlookup with multiple matches | Excel Programming | |||
![Mary[_10_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
