Formula Question

Occasional Visitor

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?

1 Reply



You may put all your codes in some column, let say to Z1:Z17 or so, and when

=IF(COUNTIF($Z$1:$Z$17,A1),"GREEN", "RED")
Related Conversations
formula for data calculation
aayushman_mishra in Excel on
10 Replies
Creating A Sublist
zjohnson in Excel on
5 Replies
Excel Forumla to exclude empty cells.
ulken2019 in Excel on
6 Replies
Need FORMULA help please!!
marislav in Excel on
4 Replies