J
jlm661
Okay i am going to try to best explain what i want to do, and ANY hel
that anyone might have will be AWESOME...
Okay I my main worksheet serves as a form for collecting data from th
one of our people here, and it is set up so that they can just ta
through and fill out the information as desired. Well to fill out som
of the boxes they have to look up values found in tables that are o
actual sheets of paper. What i would like to do is make it so tha
based on the information they enter in a few cells, excel will the
enter the information that they would have had to go searching for.
So basically they will specify the Material, weight, size, class
quantity, and product and be provided with the price.
Right now the information in hard copy form is broken down by havin
the different materials on a different sheet...then after that there i
a table on that sheet which depending on the described information yo
can find the price...see this will be so much easier for people if
can automate this process for them...here is what part of the tabl
looks like:
Wght. (¡Ý) Qty. (¡Ý) class 1 class2 Class 3 other part acc.1 acc. 2
0 0 6.2 5.24 4.28 3.32 ¡Ì
0 4 6.58 5.65 4.72 3.79 ¡Ì
0 12 6.96 6.06 5.16 4.26 ¡Ì
6 0 7.34 6.47 5.6 4.73 ¡Ì
6 4 7.72 6.88 6.04 5.2 ¡Ì
6 12 8.1 7.29 6.48 5.67 ¡Ì
18 0 8.48 7.7 6.92 6.14 ¡Ì
18 4 8.86 8.11 7.36 6.61 ¡Ì
18 12 9.24 8.52 7.8 7.08 ¡Ì
i don't know how well that came out...but if you can see...this is fo
a particular material...then if on the sheet lets say the use
specified a weight of 3, quatity 10, class 3, and accessory 1...the
the cost should be: 4.72
can anyone help me with this? :confused
that anyone might have will be AWESOME...
Okay I my main worksheet serves as a form for collecting data from th
one of our people here, and it is set up so that they can just ta
through and fill out the information as desired. Well to fill out som
of the boxes they have to look up values found in tables that are o
actual sheets of paper. What i would like to do is make it so tha
based on the information they enter in a few cells, excel will the
enter the information that they would have had to go searching for.
So basically they will specify the Material, weight, size, class
quantity, and product and be provided with the price.
Right now the information in hard copy form is broken down by havin
the different materials on a different sheet...then after that there i
a table on that sheet which depending on the described information yo
can find the price...see this will be so much easier for people if
can automate this process for them...here is what part of the tabl
looks like:
Wght. (¡Ý) Qty. (¡Ý) class 1 class2 Class 3 other part acc.1 acc. 2
0 0 6.2 5.24 4.28 3.32 ¡Ì
0 4 6.58 5.65 4.72 3.79 ¡Ì
0 12 6.96 6.06 5.16 4.26 ¡Ì
6 0 7.34 6.47 5.6 4.73 ¡Ì
6 4 7.72 6.88 6.04 5.2 ¡Ì
6 12 8.1 7.29 6.48 5.67 ¡Ì
18 0 8.48 7.7 6.92 6.14 ¡Ì
18 4 8.86 8.11 7.36 6.61 ¡Ì
18 12 9.24 8.52 7.8 7.08 ¡Ì
i don't know how well that came out...but if you can see...this is fo
a particular material...then if on the sheet lets say the use
specified a weight of 3, quatity 10, class 3, and accessory 1...the
the cost should be: 4.72
can anyone help me with this? :confused