How do I change the information that's in autofill?

How to autofill preceeding cells with appropriate information in excel?

• I am making a sheet in excel to see the cost of adding a new employee position. -In Column A, I have a dropdown already set up of the position name (Accountant, Manager, Office Worker I) -In Column B, I would like pay increase by step such as an Accountant who is at Step 3 -In the remaining columns, I want salary, FICA, Retirement, Deductions. So what I would like to do is choose Accountant, step 1 and have the Salary, FICA, Retirement, and Deductions to automatically fill in those columns. If I change it to an Accountant, Step 4, then the cells will change again. Can this be done? ***BONUS BRAIN TEASER*** Our workers get a raise after 9 months, but it depends on which year it happens. How can I make the sheet to adjust for a raise if there is one in this budget? Something like if an employee is paid $50,000 a year, in month 5 (drop down box) he gets a raise for $2,000 a year, excel will automatically show you his total wages were $50,000 a year for 4 months and $52,000 for the other remaining 8 months. Any idea?

• Answer:

  This can be easily done with a Vlookup function - you need to create a master table with all the details for the particular employee position and then lookup the values from col A from the master table - if u change the values in col a - all the values automatically changes- share the file if u need me to work on it