If Cell Contains Any Words Found in the Adjacent Cell
Please point me in the right direction. I don't know which formula(s) to use to get this output:
If A2 matches to any of the abbreviated roles in B2 then "Match" if not "No Match"
Not an exact match, but as long as column B has a minimum of 1 match, then it is a match.
A B Role VerifyRole PC PC, OD, PO Match PO PO, PO Match OD PSS, OD Match PSS PO, PSS Match OD, PC PC, OD Match OD, PC PO, PSS No Match OD, PO OD, PC, PC, PO Match
Reply With Quote