Help with Pivottable, Vlookup and Offset

[steve1040]

I have a pivottable that I'm using vlookup on.
The following works when I try and pull totals by quarter
=VLOOKUP($B5,soi_PivDB,4,FALSE) (b5 = Calendar Quarter 1-2011 Total) = 3.65

How can I pull total where b5 = Calendar Quarter 1-2011 Total
and c5 = Used Orderset - Yes Total

So using the screenshot The return result would be 3.66

Thanks
Steve

 

[Andrew Poulsom]

Welcome to MrExcel.

Why don't you use GETPIVOTDATA?

http://www.contextures.com/xlPivot06.html

 

[steve1040]

Welcome to MrExcel.

Why don't you use GETPIVOTDATA?

http://www.contextures.com/xlPivot06.html

Thanks but I never had any luck with GETPIVOTDATA.
It confuses me
For example I used the excel generated GETPIVOTATA
=GETPIVOTDATA("Risk Adjusted LOS",$B$6,"OSU","Used Orderset - Yes","DischargeQtr","Calendar Quarter 1-2011")

and tried to convert it to a dynamic function

F37 = Risk Adjusted LOS
E38 = Used Orderset - Yes Total
D37 = Calendar Quarter 1-2011
=GETPIVOTDATA($F$37,$B$6,"OSU",$E$38,"DischargeQtr",$D$37)

I don't get why this won't work - I replaced hard coded values with cell values

 

[Andrew Poulsom]

This:

E38 = Used Orderset - Yes Total

is not the same text as in the formula that was generated.