Pivot Table data lookup

[sha_007nk]

Hi All,

I have a pivot table in which I make some selections for categories.
Now, the selected categories should be looked up in a table using vlookup and corresponding data from the table displayed in a chart.

How can I lookup only the selected categories of the pivot table?


Regards,
Shanks

[noboffinme]

Hi sha_007nk,

Can you post the file you're using?

Thanks