| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
match two conditions to return value from pivot table
Pivot table setup with name in row field, week number in column value. Need
to lookup/match the week number then the name and return a 1 value from the pivot table. Is this possible? example: 1 2 3 Sales 1000.00 3000.00 Cost of Sales 350.00 1000.00 200.00 Accounting fees 50.00 10.00 30.00 Advertising 20.00 30.00 15.00 Salaries 40.00 5.00 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot table bottom ten filter with conditions | Excel Discussion (Misc queries) | |||
| Return value with 2 conditions (using Lookup/Match/Index) | Excel Discussion (Misc queries) | |||
| return values in the table with multiple conditions | Excel Worksheet Functions | |||
| Pivot Table: Return Value From Same Row | Excel Discussion (Misc queries) | |||
| need to return next match of table, only finding first match...HEL | Excel Worksheet Functions | |||
Threaded Mode
