I'm having a problem with, what I'm sure will turn out to be, a simple problem.

I have a validated list in one file, which is 20 columns of "Yes" or "No".

All I want to do in another file is say:

If any of the columns have "Yes" selected then return a TRUE response - a
simple 'OR' formula I thought.

However, if the "Yes" is in any column other than the first in the formulas
sequence, it returns a FALSE response.

Any ideas as to why it's not picking up the other columns correctly?

Thank you.