Pivot table & Vlookup

[Mohandas]

Can I use Vlookup formula to get date from pivot table

 

[bluesky63]

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

 

[GraH - Guido]

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.

 

[Mohandas]

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

 

[GraH - Guido]

Mohandas, a file would be great.... as already kindly suggested in the first reply by @bluesky63.