get remarks value base on the right CODE No.

Can anyone help with this scenario I have a data that have different name but same CODE No. I want to get the marks base on the CODE no. In column B Sheet 2 will put the marks base on the CODE no. in Sheet DATA.
I attached Image for the data and expected result. Also i put the example documents. Thank you in advance.

This the data Sheet name: DATA

Data.PNG

and this is the expected result Sheet name Sheet2

Attachment 731829