Forum Discussion
Is it possible to create a function to verify if up to 6 cells are compatible with each other?
With excel limitations (Without use of macros), is it possible to create a compatibility check from 6 different tables? Case is that I have a report consisting of several drop-down menus/lists tha...
If you are using Excel for MS365 or 2021, I'd suggest you use UNIQUE and FILTER and a structured table to define all the possible combinations. Otherwise, create the drop-down list with named ranges.
Both methods are demonstrated in the attached file.
Otherwise google for "dependent dropdown excel" and you'll find plenty tutorials on how to work with these.