Find, Match and Populate Formula

Hi Experts,

I've attached a sample record that contains 2 worksheets (StudentRecord_Sample.xls).

Sheet1 contains student record information such as: Index, Group Name, Student ID, Activities
Sheet2 contains Student ID, Index

Sheet1 is a raw data. By only using the "given" student ID in Sheet2 (column A), how would it be possible to extract the "INDEX" information and populate its information as shown in colum B (yellow highlight)? Column A is the "given" input. Column B is the desired output.

Apprecite for your kind help.

Thank you.

- Blue