Employee Database

Hi all,

I was wondering if there is a way to combine an employees name with his code.
This is what I got:
One Excel Worksheet, Sheet1 has the names and their code (A1, B1).
Sheet2 is a form where employees obligate tools.

My idea is when I type their code in the form that it automatically fills their name.

Attached is an example file.