ExcelBanter - Formula to Look up values from a pivot table

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formula to Look up values from a pivot table (https://www.excelbanter.com/excel-discussion-misc-queries/448624-formula-look-up-values-pivot-table.html)

Excel Dumbo

Formula to Look up values from a pivot table

1 Attachment(s)

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

Excel Dumbo

Any help please ?

All times are GMT +1. The time now is 03:18 AM.