Can I create a new column that returns Yes/No if there is a match in values of two other columns?

[ERing]

I have data like below with two columns (Test 1 & Test 2). I need to add a new column that returns either "Yes" or "No", depending on whether the values in columns one and two match. The match should not be case sensitive.

I'm not sure how to do this. Any suggestions are greatly appreciated.

[Laurie_H · Accepted solution]

Match = IF(UPPER(Table[Test 1]) = UPPER(Table[Test 2]), "Yes", "No")