Compare multiple columns in two different spreadsheets

I have two spreadsheets and each has three columns in particular in column: User, Section and Department. On one sheet there might be cases where the section and department associated with the user don't match with the section and department associated with the user on the other sheet. Fore example:
Sheet A (correct info)

User Section Department
John Smith IT Customer Service

Sheet B (Incorrect info)
John Smith IT Infrasctructure

I need to find a way to run a comparison between the two sheets so I can find where the discrencies are. Is there a formula that will do this? Any help you give would be appreciated. Thank you.

I'd use a VLOOKUP on this, for columns B and C
i.e. (IN COLUMN D)
=IF(OR(VLOOKUP(A1,SHEET2!A1:C500,2,FALSE)<>B1,VLOOKUP(A1,SHEET2!A1:C500,3,FALSE)<>C,"ERROR","")

This will check each on and let you know which have errors.

Hope this helps.

-Z

Thank you for the formula but I'm apparently messing it up. I'm not much of an excel person and this was just dumped on me. Here are samples from the spreadsheets in question. Can you help clarify?

Look at the formulae in added columns C and E.

Thank you! it worked beautifully!

Glad I could be of service.

-Z