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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
match two conditions to return value from pivot table
Shade13,
Your data didn't come through very well, but you should use the Excel help files to read up on the following functions: MATCH INDEX GETPIVOTDATA VLOOKUP HLOOKUP LOOKUP As a quick and dirty measure, you could use GETPIVOTDATA or do an INDEX(reference (i.e. data inside the pivot table which excludes the name and week), MATCH on the row, MATCH on the column). Best, Matthew Herbert "Shade13" wrote: 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 |
Reply |
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 |