• 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.

Pivot table & Vlookup

Hi Mohandas, why would you use Vlookup from pivot table ? I am sure there are many other effective method to achieve what you want, perhaps you can upload a sample and briefly explain what you want to achieve
 
Ever heard of GETPIVOTDATA ( ) function?
The arguments can be made dynamic by referencing another cell: e.g.
  • =GETPIVOTDATA("Number",$A$3,"Quarter",199302,"Category","Product1")
  • =GETPIVOTDATA("Number",$A$3,"Quarter",M$1,"Category",$L2)
    • where M1 = 199302
    • where L2 = Product1
To avoid #REF! errors, wrapping an IFERROR () around it might be required. Depending on the number of dimensions used in the pivot (Column/Row fields) handling this function becomes complex. I only use for simple pivots. Since you did not upload a file, I can't advise correctly.
 
i have billing number in pivot table.i have another sheet which has billnumber and amount i want to lookup the amount to another column beside the pivot. any suggestions
 
Back
Top