Need help with a formula pretty please?
Here is my test data:
COL A / COL B / COL C / COL D / COL E / COL F
12345678 / T1 / FORMULA / empty / 45678123 / T2
23456788 / T1 / FORMULA / empty / 77862335 / GH
34567888 / T2 / FORMULA / empty / 34567888 / AC
45678123 / T2 / FORMULA / empty / 67812345 / T3
56781234 / T3 / FORMULA / empty / 56781234 / CD
67812345 / T3 / FORMULA / empty / 27892375 / PO
77862335 / T3 / FORMULA / empty / 23456788 / T1
27892375 / T3 / FORMULA / empty / 12345678 / AB
77812934 / T3 / FORMULA / empty / 77812934 / X3
/ INDICATES A NEW COLUMN
The formula will go in Column C. It should show as "Not Converted" if both the data in "col A" and "Col B" is found to be an exact match anywhere in "Col E" and "Col F". If it does not match then it should show as "Converted".
This is what it should look like when done
TEST.png
Bookmarks