I'm putting together a spreadsheet where I have about 200 pieces equipment and each piece of equipment requires a set amount of time for a technician and an assistant technician to perform certain functions such as filter changing, belt changing and cleaning. This time is all based on the size of the piece of equipment, which I have together in a seperate spreadsheet.

What is the easiest way to set this up so that when I select the piece of equipment from my drop down list it will automatically populate the hourly fields for the technician and assistant technician?

Thanks!