Compare 2 sets of 3 columns

[Blakowt]

I am looking to compare 2 sets of 3 columns. Info would be something like this:

First set
Fslk AZ TA
KKsl AZ AT
ZLKK BA TA

Second set
KKsl AZ TA
Fslk AZ TA
ZLkk BQ TA

What I am trying to find are the instances that something in the second or third column has changed. The first column is the key and I'm and trying to figure out if the current 2nd and 3rd column has changed from a previous version. Also, I need the changes highlighted or in a different column.

 

[Dougie1]

Use a VLOOKUP to pull the data from the second sheet into columns D & E of the first sheet.

Then compare column B with D by inserting in column F the function =IF(B1=D1,"No Change", "Changed") and fill down.

Then compare column C with E by inserting in column G the function =IF(C1=D1,"No Change", "Changed") and fill down.

By filtering on "Changed" in F or G - you will see where the data is different.

 

[Yard]

Assuming 1st set of data in A1:C3, 2nd set of data in A5:C7

This in D5:

=IF(VLOOKUP(A5,$A$1:$C$3,2,0)=B5,"OK","2nd column changed")

This in E5:

=IF(VLOOKUP(A5,$A$1:$C$3,3,0)=C5,"OK","3rd column changed")


Then, Conditional formatting on D5 and E5 with the condition that:

Cell Value not equal to ="OK"

and format to whatever colour you like.

HTH