Hi Dee
The simple answer is yes, this formula is somewhat unrelated to your example but you'll get the point.
In this instance I'm getting the Net Sales for a Sales Person who is being found on another sheet via the VLookup.
=GETPIVOTDATA("Net Sales",$P$15,"Sales Person",VLOOKUP($E$42,Sheet1!$C$4:$D$7,2,FALSE))
Hope this helps!