Formula to Look up values from a pivot table

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
+-------------------------------------------------------------------
 
E

Excel Dumbo

Any help please

+-------------------------------------------------------------------
+-------------------------------------------------------------------
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Look UP formula for 2 and 3 conditions 1
Look UP using 4 criterias 2
Vlookup using two criteria -not working 2
Look up with multiple variables 1
Complicated Look Up (without making changes to the blank spaces in the table) 2
Formula to calculate commission based on sliding scale 2
Formula- Count of items that meet a specific range criteria 4
Tidying up workbook (and pivot table help)... 1

Top