Prev: VBA to check omissions and show/hide form
Next: Set object with a function
From: Shade13 on 19 May 2010 16:54
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



From: Matthew Herbert on 20 May 2010 00:59
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
>
>
>
 | 
Pages: 1
Prev: VBA to check omissions and show/hide form
Next: Set object with a function