Hello,
In the attached file, all the values B11:E13 are returned from data in different tabs using using vlookup or index functions
I have a requirement where the data in B11:E13 should be filtered based on the filter value selected in B7.
1) None of the formula in B11:E13 have any criteria or validation for the Account Type value in B7. So none of the formula check if Account Type.
2) If I add a table to map Sector1, Sector2 and Sector3 as Premium or Regular(the values in B7), is there a way to filter out the data in B11:E13 based on the filter value selected in B7.
Bookmarks