ExcelBanter - to check if the values in two sheets are equal

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - to check if the values in two sheets are equal (https://www.excelbanter.com/excel-discussion-misc-queries/167797-check-if-values-two-sheets-equal.html)

SKP

to check if the values in two sheets are equal

to check if the values in two sheets are equal

Mike H

to check if the values in two sheets are equal

A couple of ways:

1. =A1=Sheet2!A1
2. =IF(A1=Sheet2!A1,"The same","Different")

Mike

"SKP" wrote:

to check if the values in two sheets are equal

All times are GMT +1. The time now is 11:49 PM.