Home > Forum Home > Automating Data Analysis Tasks > Fetch Data automatically in a single cell > Referencing functions for filtered data Share

Referencing functions for filtered data

Excel Help for Referencing Functions For Filtered Data in Automating Data Analysis Tasks


Forum TopicLogin

Referencing Functions For Filtered Data

Rate this:
(3/5 from 1 vote)
Oops It is difficult to know exactly the requirement from your detail; however it seems that you need to reference data from a separate workbook based on results of a pivot table filter.

In the this case, a referencing function may work using MATCH and INDEX or LOOKUP functions.
 Excel Business Forums Administrator
 Posted by on
 
View Full Post

Find relevant Excel templates and add-ins for Referencing functions for filtered data in the