Derive a value across 2 worksheets

[JonUK01]

Hello, I'd be grateful for some help.

I've got 2 worksheets in the same workbook. Each sheet has a column containing an Employee ID Number. The number of records on each sheet is not the same and they are not sorted on the same criteria.

Sheet1

Col D - Employee ID
Col AI - Rating (currently blank cells)

Sheet 2

Col A - Employee ID
Col K - Rating

I would like a formula/function to go in Sheet 1 Col B cells which derives the Rating against an Employee ID based on the information held in Sheet 2.

I've tried to work out the formula, but get very confused with Lookup functions, which may not be applicable anyway.

Thanks in advance