Sep 28 2020 05:32 AM
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.
Sep 28 2020 05:40 AM - edited Sep 28 2020 05:40 AM
@AFPEMI ,
In Position: =VLOOKUP($C9,Table1,2,FALSE)
In Hourly Rate =VLOOKUP($C9,Table1,3,FALSE)
Sep 28 2020 05:42 AM
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.