Hi,

I building a sensitivity analysis model of historical S&P prices. So far I have set up a pivot table on one tab using the year, financial quarter, and date as row labels, and have set up a max, min, avg. column through value field settings. The pivot table works great, but the problem I've had is pulling that data into the master sheet.

I've tried to pull the max, min, and avg. using vlookup, but I've only been successful in getting the max, min, and avg. of either that specific year OR that specific quarter, and I need to pull the max, min, and avg. of both that specific quarter AND that specific year.

Name: S&P.PNG
Views: 1
Size: 22.5 KB

Hopefully I've attached what the master sheet looks like. Basically I just need the max, min, and avg. to show the same thing for every specific quarter AND year, I understand the values will repeat for each date.

Any help would be greatly appreciated, I hope I was as clear as possible. Thanks