Use a LOOKUP function, such as: =LOOKUP(10^10,SEARCH(SFS2:$F$170,B2),SGS2:SG$170) Here, the yellow highlight is the first column (i.e.,...

Posted Date: