Compare data between 2 spreadsheets

[Chezzy]

Hi,

Sorry if this has already been mentioned but i couldn't find an answer to my question.

I have 2 spreadsheets.

First spreadsheet with 4 columns:

(A)Worker Number / (B) Worker Name / (C) Job Title / (D) Reports to7

Second spreadsheet with same info but

(E)Worker Number / (F) Worker Name
Spreadsheet 1 data is current data and i need to compare the A & B to the E & F column in spreadsheet 2 which is old data but basically the same information.

I need it to return me a message, on the 2nd spreadsheet in the "G" Column basically telling me if E & F matches A & B in Spreadsheet 1. Stating either "Correct" or "Incorrect".

Thanks for any help in advance and i hope my explanation hasn't confused anyone.

If possible, if someone could write me a formula to input in column G in spreadsheet No2 that would be great.

I'm not great with excel but i know this can be done and just need any help i can get to complete this task quicker.


Thanks!

 

[Robert Mika]

Hi Chezzy,
From cell e2 sheet1 copy down
=A2&b2

In sheet2 E2 copy down:

=IF(ISNUMBER(MATCH(E2&F2,Sheet1!$E$2:$E$500,0)),"Correct","incorect")

 

[Akinrotimi]

Simply paste the formular below on G2 of sheet2:

=IFERROR(IF($E2&$F2=Sheet1!$A2&Sheet1!$B2,"correct","incorrect"),"")

Regards

'Rotimi

 

[Robert Mika]

Simply paste the formular below on G2 of sheet2:

=IFERROR(IF($E2&$F2=Sheet1!$A2&Sheet1!$B2,"correct","incorrect"),"")

Regards

'Rotimi

Rotimi,
Your formula will only compare one row at a time.
Not sure if this is what chezzy is lookig for.
Besides IFERROR will only work in Excel 07 and 10