match two conditions to return value from pivot table

S

Shade13

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
 
M

Matthew Herbert

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top