VLOOKUP and IF

[amattey]

I am trying to create a formula that IF A2 in sheet 1 is equal to any cell in Sheet 2 but in the same column, it will say no change. Otherwise it will say change.

This is what I try to do

=IF(VLOOKUP(A1,'Sheet2'!A:A,TRUE),"No Change","Change")

Could anyone help me see what I am doing wrong?



Thank you!

 

[mikerickson]

Something like
=IF(ISNUMBER(MATCH(Sheet1!A2, Sheet2!A:A, 0)), "No Change", "Change")

 

[VoG]

Try

=IF(ISNUMBER(MATCH(A2,Sheet2!A:A,0)),"No change","Change")

 

[amattey]

Would it work even if the cell contains a mixture of text and number?

 

[VoG]

Yes.

 

[amattey]

Thank you, it did work!