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

@AFPEMI ,

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

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

@AFPEMI 

Enter the following formulas in D9 and E9:

 

=IFERROR(VLOOKUP(C9,Table1,2,FALSE),"")

=IFERROR(VLOOKUP(C9,Table1,3,FALSE),"")

 

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