to check if the values in two sheets are equal

  • Thread starter Thread starter SKP
  • Start date Start date
A couple of ways:

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

Mike
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Value if two cells are true 2
cell on sheet 1 equals cell on sheet two 2
Rows which are equal 7
How to locate which cells add up less than or equal to a certainnumber (where numbers can be repeate 1
how to create a new sheet when adding values in column if it not e 1
Sum if two varialbles (sum if and if) 4
Determining if two columns values are equal/close 4
adding text according to col with equal date 2

Back
Top