Quote:
Originally Posted by excelledsoftware
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.
|
On sheet1 the rows all defined by the person doing whatever job they are assigned for the day.
So, for an example of what I am hoping to be able to do, if we look at cell A2, (Susan,) the values for cells B2:G2 would be entered manually. Then based on what the values are in cells C2 and F2, values for cells H2 and K2 would be determined for me using the lookup/if function to look at the table that is included starting at T4 ending at Y18.
I hope that makes sense. This is starting to make me go at little looney trying to piece it together on my own.
My excel knowledge is mostly self taught from reading forums like these, and some beginner level courses I took through my work.
Any help would be most appreciated. I re-saved and attached the workbook in question and filled in some of the values on sheet1 in hopes it can do a better job showing what I am hoping to accomplish than my long winded typed explanation may be doing now.