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

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