I am trying to create a workbook that I can use to easily record labor efficiency based on a number of variables.

I need to be able to enter some of the data and have corresponding data pulled for me from a table.

I want to be able to enter the part and sequence numbers that the person worked on for the day and have the corresponding crew size and rate filled in for me based on what I enter for the part and sequence numbers.

Is there a way to do this?

Attached Files

work worksheet.xlsx (14.5 KB, 23 views)