Ultimately I am trying to evaluate the D column to see if it contains any of the words: Missed, Hold, or By-passed, but I also want to evaluate the B column to see if it contains the number 1.
If the evaluation finds any of these, in either column B or D, I want it to display as "evaluate" whereas if none of these are found, I want it to display "no concern"
I have tried the formula below, with very little success.
=IFS(ISNUMBER(SEARCH("hold",D3:D3000)),IF(ISNUMBER(SEARCH("1",B3:B3000)),IF(ISNUMBER(SEARCH("missed",D3:D3000)),IF(ISNUMBER(SEARCH("by-passed",D3:D3000))"evaluate"," no concern")))
Your help is greatly anticipated!
Bookmarks