How to check if a cell contains any of the values of another range of cells?

This is truly optimized: if at least one operand contains an error, you will find out about it immediately, and not after a month of using the table, when the error appears due to a change in data somewhere completely different.

1 Like