CODEWITHSUNDEEP
excelexcel-formula
Tairoc
Tairoc

Reputation: 661

Compare two columns cellA and cellB and notate findings on cellC?

I have three columns A, B and C.

Columns A and C have values that may or not be the same.

I will like to compare the two columns.

If data found on cellA is also on cellB, I will like to put a Y on cellC. If not, a No.

Upvotes: 0

Views: 70

Answers (1)

Aleksandar Misich
Aleksandar Misich

Reputation: 502

You can have cell C be a simple formula such as

=IF(A1=B1,"Yes","No")

This will test if The adjacent A and B cells are Equal and show the value "Yes" if they are, and "No" if they are not.

Upvotes: 1

Related Questions