Sep 20 2022 11:17 AM
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.
Sep 20 2022 12:47 PM
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)