I have a question. I hope you can help. I have a file that has a value in column A. In the Result column, I’d like to put GREEN if any one of these values is in Column A.
I can do it if it is one value (M1C), but not a whole bunch of values at once.
Do you know if the formula can accommodate multiple values to check for?
You may put all your codes in some column, let say to Z1:Z17 or so, and when