| 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 Topic | Login |
Referencing Functions For Filtered Data | Rate this: (3/5 from 1 vote) |
 |
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 Excel Helper on | ||
| View Full Post |
| Find relevant Excel templates and add-ins for Referencing functions for filtered data in the Excel Business Solutions Directory |