I have a formula that isn't quite working. Need to look in column "B" for RIGHT, LEFT, RT, LT, R, L & return a "R" or "L" in a new column. If not present, then the cell = blank. An example would be: SQUAMOUS CELL CARCINOMA SKIN/ L EAR AND EXTRN AURIC CANAL It should return a value of "L". Left cannot be a wildcard because the word "CLEFT" can also be in column B. Here is the formula i am using - but it is returning all "R"s regardless. =IF(COUNTIFS(B1609,"Right")>0,"R",IF(COUNTIFS(B1609,"*RT*")>0,"R",IF(COUNTIFS(B1609,"Left")>0,"L",IF(COUNTIFS(B1609,"LT")>0,"L",IF(COUNTIFS(B1609,"*R *")>0,"R",IF(COUNTIFS(B1609,"*L *")>0,"L "," "))))))
Solved by C. J. in 27 mins