I've tried searching for this, but not having any luck so far.
I am looking for a formula to search for specified text in column A, and if found in column A, it then will search a specified cell in the same row for whether it has the text "OFF" or not. If it does have "OFF", it will return a "NO", if it doesn't have "OFF", if would return a "YES".
Appreciate any assistance.
I am looking for a formula to search for specified text in column A, and if found in column A, it then will search a specified cell in the same row for whether it has the text "OFF" or not. If it does have "OFF", it will return a "NO", if it doesn't have "OFF", if would return a "YES".
Appreciate any assistance.