I have 4 columns; I need to find the following
Column A
A2 If response is either Yellow, Gold or Orange
Column B
B2 If text contains “Shirt”
Column C
C2 If text does NOT contain “Apple”
Column D
D2 Text is equal to YES
I would like to know if they are a MATCH, NOT a Match
Please let me know if you need any more information, thanks
Bookmarks