Home

Formula Question

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

M1C,M1R,M9V,M9W,M9L,M9M,M3N,M3L,M3M,M3J,M3K,M3H,M2R,M2M,M2N,M2M.M2K,M2H,M2J,M1W,M1V,M1T,M1S,M1X,M1B

 

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

Hi,

 

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
Extentions Synchronization
Deleted in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
36 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies