Link to home
Start Free TrialLog in
Avatar of Allen Prince
Allen PrinceFlag for United States of America

asked on

How to Filter an Excel list using a formuls in a cell?

Excel formula experts!

 We have several categories and sub categories with values recorded in a list
I want to "filter" the list and place the values in a tabular form in a separate Excel Workbook.
loookup-filter.xlsx
ASKER CERTIFIED SOLUTION
Avatar of Flyster
Flyster
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Allen Prince

ASKER

One answer saved hours of reading through Excel Bible or Mr Excel or searching!
Worth every dime of the annual subscription!
Or you could use Index/match and array formulae: see attached.
Copy-of-loookup-filter.xlsx
Oops.  Just saw previous answer was accepted while I was typing.  I'll leave my comment for future reference if anyone reads this thread.