Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Senior Member
 
Posts: 105
Default Formula to Look up values from a pivot table

Hello,

Could you please suggest a formula to look up values from a pivot table without altering the structure of the pivot table ? PLease refer below attachment

If u suggest SUMPRODUCT, I would like to mention the pivot table keeps growing month by month, and as it gets bigger, it takes lot of time for excel to derive values and sometimes it stalls the workbook

Thanks
Attached Files
File Type: zip Look Up Data New.zip (4.1 KB, 36 views)
  #2   Report Post  
Senior Member
 
Posts: 105
Default

Any help please ?
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
Max Values in Pivot Table Deriv001 Excel Discussion (Misc queries) 0 April 9th 09 06:06 PM
Pivot table values RW Excel Discussion (Misc queries) 2 February 28th 09 03:23 AM
Copying values from pivot table to cells outside pivot table richzip Excel Discussion (Misc queries) 4 January 17th 08 12:03 AM
formula to get values from pivot table Minerva Excel Worksheet Functions 1 February 15th 06 02:41 PM
Why won't pasted values from a formula appear in a pivot table B_4j Excel Discussion (Misc queries) 1 June 24th 05 06:53 PM


All times are GMT +1. The time now is 12:28 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"