Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
MIVELD
 
Posts: n/a
Default Pivot Table Lookup Grid


Hi

I am looking for a way to lookup a particular cell within a pivot
table

the pivot table contains 8000 account numbers down the left hand side
and the Months accross the top and sales in the grid.

Am am wanting to put the account number and Month into a cell and pull
through the sales for that month i am also looking to then show the
previous and next 3 months sales in the previous and next 3 cells on
the same row, Smaple of what i want below but i cant find the right
formula.

Other problem is that the pivot table is built of a server and the
account numbers are not sequential

Any Ideas


Month
Aug-05

Account No -3 -2 -1 Aug-05 +1 +2 +3
13758
12547
12357
12369
14789
36541
25487


Cheers

Al


--
MIVELD
------------------------------------------------------------------------
MIVELD's Profile: http://www.excelforum.com/member.php...o&userid=24562
View this thread: http://www.excelforum.com/showthread...hreadid=467097

  #2   Report Post  
Bernie Deitrick
 
Posts: n/a
Default

The logic will be

=INDEX(PIVOTTABLE,MATCH(Company,PTColumn,False),MA TCH(Date,PTHeader,False))
=INDEX(PIVOTTABLE,MATCH(Company,PTColumn,False),MA TCH(Date,PTHeader,False)+1)
=INDEX(PIVOTTABLE,MATCH(Company,PTColumn,False),MA TCH(Date,PTHeader,False)+2)
=INDEX(PIVOTTABLE,MATCH(Company,PTColumn,False),MA TCH(Date,PTHeader,False)+3)
=INDEX(PIVOTTABLE,MATCH(Company,PTColumn,False),MA TCH(Date,PTHeader,False)-1)
=INDEX(PIVOTTABLE,MATCH(Company,PTColumn,False),MA TCH(Date,PTHeader,False)-2)
=INDEX(PIVOTTABLE,MATCH(Company,PTColumn,False),MA TCH(Date,PTHeader,False)-3)

The specifics depend on the format of the PT headers.

--
HTH,
Bernie
MS Excel MVP


"MIVELD" wrote in message
...

Hi

I am looking for a way to lookup a particular cell within a pivot
table

the pivot table contains 8000 account numbers down the left hand side
and the Months accross the top and sales in the grid.

Am am wanting to put the account number and Month into a cell and pull
through the sales for that month i am also looking to then show the
previous and next 3 months sales in the previous and next 3 cells on
the same row, Smaple of what i want below but i cant find the right
formula.

Other problem is that the pivot table is built of a server and the
account numbers are not sequential

Any Ideas


Month
Aug-05

Account No -3 -2 -1 Aug-05 +1 +2 +3
13758
12547
12357
12369
14789
36541
25487


Cheers

Al


--
MIVELD
------------------------------------------------------------------------
MIVELD's Profile: http://www.excelforum.com/member.php...o&userid=24562
View this thread: http://www.excelforum.com/showthread...hreadid=467097



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot table doing a lookup without using the lookup function? NGASGELI Excel Discussion (Misc queries) 0 August 2nd 05 05:08 AM
Change Data In Pivot Table John Calder New Users to Excel 1 July 7th 05 10:41 PM
Pivot table, dynamic data formula Excel GuRu Excel Discussion (Misc queries) 3 May 3rd 05 10:45 PM
Can I use a 'lookup' to a Pivot Table? Chrism Excel Discussion (Misc queries) 1 April 7th 05 06:51 PM
Pivot Table Problems Rachel Gonsior Excel Discussion (Misc queries) 3 March 21st 05 08:24 PM


All times are GMT +1. The time now is 03:00 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"