Drop down list equal to another cell

Occasional Visitor

Hello, I'm working on updating one of our payroll worksheets.   I want to create a drop down list of our different jobs, and when one of those is chosen it brings in the cost for that job.  For example, in A1 is a list of job types formatted as a drop down.  If "Electrical" is chosen, I want the corresponding % cost to automatically be pulled into B1.  Same for other jobs such as painting and carpentry.  At the bottom of our sheet I have a table that lists each job type as well as the Cost. 

1 Reply


Hello this is a typical application for VLOOKUP() or XLOOKUP. Have a look at the help pages.
=XLOOKUP(what_you_are_loocking_for, where_you_want_to_look, what_do_you_want_back)