I have a substitute formula that is working great. I need a modification to the substitute formula so that it returns an “Empty Cell” when there is “Brown, Purple and Blue” in any cells in column A.
Existing Formula: =IF(AND(SUBSTITUTE(B2," ","")="AlmondPapayaPapaya",OR(C2={"Home","Key","Door"})),"Yes","")
New Scenarios:
IF A2 = Brown and B2 = Almond Papaya Papaya, return “Empty cell”
IF A5 = Purple and and B5 = Almond Papaya Papaya, return “Empty cell”
IF A12 = Blue and and B12 = Almond Papaya Papaya, return “Empty cell”
Thanks for your help in advance
Bookmarks