Auto-fill adjacent cells

Occasional Visitor

Good morning,

I have a dropdown list on sheet "Team "cell C9 which contain the names of all employees in the company. This list is fed from a table on sheet "Personal".

I'd like to auto fill the adjacent cells with the corresponding job title and hourly rate for the selected employee on C9.

Thanks for your help.

2 Replies


In Position: =VLOOKUP($C9,Table1,2,FALSE)

In Hourly Rate =VLOOKUP($C9,Table1,3,FALSE)


Enter the following formulas in D9 and E9:





Copy D9:E9 to D10:E13, to D16:E20 etc.