Hello,
I would like some help with a formula.
There are two columns (Col A and Col B) with text in each, and I also have an additional 2 columns (Col E and Col F) with criteria text.
I need the formula to check if the two separate text entries in Col A and Col B columns match the text in adjacent criteria columns (Col E and Col F), and if so, place a 1 in Col C, if not, 0 in Col C.
Attached an example spreadsheet to hopefully explain things are little more clearly.
Thanks in advance for your assistance!
Bookmarks