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.
