vlookup using slicer selection in pivot table

[288enzo]

Long story short, I have a 4 slicers that control my pivot table. In the past I had used filters, and based on the filter selection a formula "vlookup" would give me a value. I've now done away with the filter and have moved to slicers. How can I achieve the same results with my "vlookup" formula using a slicer and not a filter? The filter was easy, because the data for the lookup was in a specific cell. I don't know how to do that, or if that can be done with a slicer.

The file is massive, please let me know what other info I can provide to help you help me

Thank you, and Happy holidays.

 

[ms_excel_recal_or_die]

Hi @288enzo ,

Could you provide a small sample of the file? I think I understand what you´re looking for, but a small sample would greatly help me to set you up your requirement.

Happy holidays as well,

Regards,
Carlos