Cells A1:A4 can contain any of the following values:
0A, 0B, 0C, 0D, 0E
1A, 1B, 1C, 1D, 1E
2A, 2B, 2C, 2D, 2E
3A, 3B, 3C, 3D, 3E
4A, 4B, 4C, 4D, 4E
5A, 5B, 5C, 5D, 5E
If any cell in the range A1:A4 contains any of the following values; "3E, 4D, 4E, 5A, 5B, 5C, 5D, 5E," then I want cell A5 to return the text "MAH"
Perhaps this... =IF(SUMPRODUCT(COUNTIF(A1:A4,{"3E","4D","4E","5A","5B","5C","5D","5E"}))>=1,"MAH","")
adjust the range as needed.
Last edited by Sam Capricci; 06-12-2019 at 03:42 PM. Reason: had greater than/equal to backwards.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Thank you. Just nee to make it >=1 and it works fine.
Yes, I had it backward but edited it though you apparently made the change too.
glad that did it for you, don't forget to mark the post as solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks