Populate data from Master list

[shingi]

Was wondering if you could help me with this-

I have master data for employees ( employee name, ssn, deptt name) that I want to use in different files for calculating PTOs/ Bonuses etc.
So if there a termination/ admission I don't have to update the employee file all the time. I can just update the master file and the the data in PTO/ bonus worksheet will automatically update with the employee information.

Appreciate your help!

[alansidman]

you might be able to achieve what you need with the vlookup function.

Look at this link: http://www.techonthenet.com/excel/formulas/vlookup.php