How do I compare information on two different sheets with different data

[neney1984]

I have two versions of an employee spreadsheet saved on two different dates that I need to compare. Master employee spreadsheet saved on 02.11 has 151 rows and goes to AF. Master employee spreadsheet saved on 02.22 has 154 rows and goes to BF.

To start off I created a new workbook and created three sheets. in sheet 1 I copied the contents of 02.11 and in sheet 2 I copied the contents of Master 02.22. Sheet 3 is my VLook sheet. Basically I'm interested in comparing the information in sheet 1 to the information in sheet two and having it populate in sheet 3.At this point I'm only concerned with finding the discrepancies. Sheet three has three columns, title manager and salary. I used the following Vlook up formulas in the the three columns to find the discrepancies. VLook
=VLOOKUP ('Master 02.11'!A2,'Master 02.22'!$A$1:$F$154,1,FALSE).

Title: Found in B2 of sheet 1 compared to F1 of sheet2
Manager: Found in D2 of sheet 1 compared to U2 of sheet 2
Base Salary Found in R1 of sheet1 compared to Al of sheet 2

This would work great if the sheets had the exact same information, but since they do not I'm having trouble.

Does anyone have any ideas on how I can make this work using an excel formula. I've already spent 4 hours just to get to this point as my excel skills are pretty basic.

Thank you!

 

[cjcobra]

Are you looking for discrepancies in the names, or salaries? You are looking up column "1" in your formula, so I assume names.

I would use an ISERROR to check for the names: If it doesn't find the name, it will list the name in error.

=if(iserror(VLOOKUP ('Master 02.11'!A2,'Master 02.22'!$A$1:$F$154,1,FALSE),'Master 02.11'!A2,"")

If you want to compare salaries, something like this may work. if the vlookup salary doesn't match the other vlookup salary, put "Error", else blank

=if(VLOOKUP('Master 02.11'!A2,'Master 02.22'!$A$1:$F$154,2,FALSE)<>VLOOKUP('Master 02.22'!A2,'Master 02.22'!$A$1:$F$154,2,FALSE),"Error","")

 

[neney1984]

Hi cjcobra,

Thank you for your reply. I'm interested in-comparing the names, titles, salaries and manager information. I tried using the formulas you provided but I couldn't get them to work. I get an error message.

Thanks,

Neney1984