• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Can i integrate VLOOKUP with GETPIVOTDATA formula?

Dee

Member
Hi,

I have my pivot table in Sheet2 (Rows - Qtr implemented & Project manager, Column - 2010 impact)and i need to extract data in sheet3 based on Qtr implemented & project manager which is there in column 'B' of Sheet3.


Thanking you in advance,

Dee...
 
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!
 
Back
Top