I need to compare a column from two different Excel sheets and return a value of true or false.
Take the 2minute tour
×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.
Comparing the whole column:
or comparing a cell in the two sheets:
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. 

