Dynamically Update and Filter Text

Occasional Visitor

Hello Everyone,


I am working on excel 2019. I created a report where the results of my survey are dynamically transferred from my pivot table to my report. 

When I change the filter on my pivot table (which is the name) everything updates perfectly on my report.


The problem: I have text format in my survey.

I would like to automatically update my report using the text when I change the filter.


I tried Vlookup, hlookup, index match. Nothing seems to work



0 Replies