E
Excel Dumbo
Hello,
Could you please suggest a formula to look up values from a pivot tabl
without altering the structure of the pivot table ? PLease refer belo
attachment
If u suggest SUMPRODUCT, I would like to mention the pivot table keep
growing month by month, and as it gets bigger, it takes lot of time fo
excel to derive values and sometimes it stalls the workbook
Thank
+-------------------------------------------------------------------
|Filename: Look Up Data New.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=849
+-------------------------------------------------------------------
Could you please suggest a formula to look up values from a pivot tabl
without altering the structure of the pivot table ? PLease refer belo
attachment
If u suggest SUMPRODUCT, I would like to mention the pivot table keep
growing month by month, and as it gets bigger, it takes lot of time fo
excel to derive values and sometimes it stalls the workbook
Thank
+-------------------------------------------------------------------
|Filename: Look Up Data New.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=849
+-------------------------------------------------------------------