Quote:
Originally Posted by CSzoke
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?
|
Definitly a way to do this but you have a lot of fields on your spreadsheet. If you just want formulas to fill in results on the crew size and rate columns then I guess all we need to know is an example. What would you put in for the seq and part and what result do you want to come out on the rate and size.
List at least 5 examples so a formula can be created. Again it shouldnt be too hard once we get this information.