ExcelBanter - Look Up values from a pivot table

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

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

- - Look Up values from a pivot table (https://www.excelbanter.com/excel-discussion-misc-queries/449315-look-up-values-pivot-table.html)

Excel Dumbo

Look Up values from a pivot table

1 Attachment(s)

Hello Friends,

Please refer attached excel sheet and kindly suggest a lookup formula referencing a pivot table. I have provided desired answers in the sheet.

Thanks
Excel Dumbo

All times are GMT +1. The time now is 02:12 AM.