Forum Discussion

Copper Contributor

Jul 06, 2022

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...

developer

excel

Formulas and Functions

PeterBartholomew1

Silver Contributor

Jul 06, 2022

ChristianHin

Adding to Riny_van_Eekelen 's suggestion, you could add a named formula

"IncompatibleSelection"
= OR(ISERROR(
     FILTER(Table1, (Table1[Menu1]=Option1)*(Table1[Menu2]=Option2))
  ))

to control conditional formatting. It is now also possible to control the options available within a single dataset so that each choice restricts the other options (eg selecting soda will prevent breakfast from being selected as well as the other way around). I understand that this is not what you require though.