Auto-fill adjacent cells

%3CLINGO-SUB%20id%3D%22lingo-sub-1719933%22%20slang%3D%22en-US%22%3EAuto-fill%20adjacent%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1719933%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20morning%2C%3C%2FP%3E%3CP%3EI%20have%20a%20dropdown%20list%20on%20sheet%20%22Team%20%22cell%20C9%20which%20contain%20the%20names%20of%20all%20employees%20in%20the%20company.%20This%20list%20is%20fed%20from%20a%20table%20on%20sheet%20%22Personal%22.%3C%2FP%3E%3CP%3EI'd%20like%20to%20auto%20fill%20the%20adjacent%20cells%20with%20the%20corresponding%20job%20title%20and%20hourly%20rate%20for%20the%20selected%20employee%20on%20C9.%3C%2FP%3E%3CP%3EThanks%20for%20your%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1719933%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1719978%22%20slang%3D%22en-US%22%3ERe%3A%20Auto-fill%20adjacent%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1719978%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F811642%22%20target%3D%22_blank%22%3E%40AFPEMI%3C%2FA%3E%26nbsp%3B%2C%3CBR%20%2F%3E%3CBR%20%2F%3EIn%20Position%3A%26nbsp%3B%3DVLOOKUP(%24C9%2CTable1%2C2%2CFALSE)%3C%2FP%3E%3CP%3EIn%20Hourly%20Rate%26nbsp%3B%3DVLOOKUP(%24C9%2CTable1%2C3FALSE)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
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
Highlighted

@AFPEMI ,

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

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

Highlighted

@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.