Quote:
Originally Posted by CSzoke
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. |
Ok there are some fairly complex formulas that will accomplish this however my suggestion is to add 2 columns that you will hide that takes both the part and seq and puts it into 1 string. Then you just need to write a very common vlookup to accomplish what you want. Otherwise what you want is a formula that performs a lookup based on 2 criteria. I have attached your spreadsheet with edits to show the column idea as well as the vlookups. If you autofill it down remember to lock the numbers for your vlookup formulas.
Hope this helps.