Compare Values in Excel

i have a spreadsheet that contains account number, account Name and Model ID.

I want to compare that with a similiar spreadsheet that contains the same info.  

Spreadsheet  1

A:   Account number
B:   Account Name
C:  Model ID

Spreadsheet 2

A:   Account number
B:   Account Name
C:  Model ID


so I want to see if for each matching account number from both spreadsheets if the Value for Model ID is different
seamus9909Asked:
Who is Participating?
 
FamousMortimerCommented:
You will have to adjust Sheet2!$A$2:$C$8 in the formula to the range of the table on the second sheet.  Please see the attached example workbook.

If you attach a copy of your workbook, I can add the conditional formatting for you.
0
 
FamousMortimerCommented:
You can use conditional formatting to show the model id's that are different with the following formula
=NOT(C2=VLOOKUP(A2,Sheet2!$A$2:$C$8,3,FALSE))

Open in new window


see attached workbook
Q-28245055.xlsx
0
 
seamus9909Author Commented:
That doesnt work, it returns an error.
0
 
seamus9909Author Commented:
0
 
FamousMortimerCommented:
Here you go.  I added conditional formatting so the Model ID will show in red if it does not match the PRU sheet.  I also added a column if you need called Model Matches PRU so you can sort if needed.
AMTRUST-UMA-MODEL.xlsx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.