2 workbooks and matching data

Hello,

I have an excel file that has 6 Worksheets which have various other formuals already built into them.
I am working with 2 of the worksheets to try and create another formula.
What I want is to be in worksheet 2 and have excel match in worksheet 1 and 2 the SIN numbers of our employees.
Then I want excel to find the corresponding department that goes with that specific SIN number in sheet 1 and put it in sheet 2 under the department tab

Sheet 1
A - Departments
G- SIN's

Sheet 2
A - Departments
G - SIN's

I have this formula but it does not give me the exact department that corresponds to the SIN number, it just gives me the next department code in the list from Sheet 1, because in Sheet 1 the person is listed twice in a row but not in sheet 2.
=IF(MATCH($G8,'Detail Report'!$G$7:$G$209,0),'Detail Report'!$A7,0)

Please help

no the same departments

okay so i would just use vlookup or I would combine with a match formual?

Thanks for your help Arlette

okay thanks

It is still not giving me the excat department that corresponds to the persons sin number, it is just giving me the next department in the row.

=VLOOKUP('Detail Report'!A8,'Detail Report'!A7:G208,1,FALSE)
is the formula incorrect. I can not move the columns around because there are other formulas built into those columns.

also the 1st sheet is called Detail Report, 2nd sheet is called per preson detail report.

thanks again for all your help