Compare a column from two different sheets and return true/false

Question

I need to compare a column from two different Excel sheets and return a value of true or false.

mcalex · Answer 1 · 2012-12-12 09:51:54Z

up vote 2 down vote

Comparing the whole column:

=(Sheet1!A:A=Sheet2!A:A)

or comparing a cell in the two sheets:

=(Sheet1!A1=Sheet2!A1)

This will put TRUE in the cell where the formula is, if the two columns or cells are the same, and FALSE if they're different.

edited Dec 12 '12 at 9:51

answered Dec 12 '12 at 6:41

mcalex
84717

1 Answer