I have the following table
COLUMN A | COLUMN B | COLUMN C | COLUMN D | IS COLUMN A+B EXACTLY EQUALS TO C+D |
A | B | C | D | NO |
X | Y | X | Y | YES |
word1 | word2 | word1 | word2 | YES |
Is it possible to display NO or YES as in the 5th column of the table above ?
I already tried to use VLOOKUP like this “=VLOOKUP(A2:B2;C2:D2;1;1)” but it doesn’t works
EDIT : I put a wrong title, I didnt want to say “contains” but “is exactly equals to”, I edited the title