I'm trying to write a formula that will lookup values from a data set based on a pivot table filter. I was using a vlookup but it breaks when new filters are added/moved around because the lookup value moves as a result. What formula can I use to lookup a moving lookup reference? The data is not being pulled from the pivot table itself (because I want to show that info across the top, not in the pivot) but from the data set used to create the pivot.
Thank you!
Bookmarks