| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to use index match for multi lookups?
I have two worksheets I am working on. On one worksheet I have the same
project number listed multiple times with $ amounts listed by months. On the other worksheet I need to sum the $ amounts by project number and by month. How can I do this with reliable accuracy? Data example: Project # Month Amt $ 4004 Jan-07 50 4004 Jan-07 25 5005 Feb-07 35 5005 Feb-07 40 5005 Jun-07 50 6006 Apr-07 75 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| INDEX / MATCH performance for lookups | Excel Worksheet Functions | |||
| match in multi-column and multi-row array | Excel Discussion (Misc queries) | |||
| lookups and match | Excel Worksheet Functions | |||
| SUM of INDEX lookups | Excel Worksheet Functions | |||
| Multi-lookups on variable data | Excel Worksheet Functions | |||
Threaded Mode
