How can I use a vlookup in a UserForm

I have created the attached UserForm and I am now attempting to use a Vlookup or VBA code to make filling the form out easier.

Basically, when the Manager inputs the employees name, I would like it to auto populate the supervisor and employee ID number.

The above information is currently housed on the Reference Page. I have watched videos, tutorials and researched the web but still can not figure out how to make this happen.

Please overlook the "REF" column as that was supposed to attach a # to the row but I am going to do something different.

Thank you in advance for the assistance.