Return the corresponding row header based text contained in data set.

[Manny Wilkins]

I want to return the relative name from column A in cell B16 if the data set = "ORS". I wrote the following formula and it works fine.
=@IF(COUNTIF($B$6:$D$13,"ORS")>1,"Check Call Schedule",INDEX($A$6:$A$13,SUMPRODUCT(($B$6:$D$13="ORS")*(ROW($A$6:$A$13)-ROW($A$5))),))

This Issue:
However, sometimes the user will add other text to this designation such as ORS/GOP. I need the formula find the text ORS in any cell in the array, even if it is combined with other designations.

 

[Fluff]

Hi & welcome to MrExcel.
How about
=IF(COUNTIF($B$6:$D$13,"*ORS*")>1,"Check Call Schedule",FILTER(A6:A13,(ISNUMBER(SEARCH("ORS",B6:B13)))+(ISNUMBER(SEARCH("ORS",C6:C13)))))