ISSUE:
I have looked and tried to use the vlookup, hlookup functions and I am unable to get anything started.
I would like to be able to choose a Size from a drop down list, that will autopopulate 1 of 2 lists of products and prices. The parts are specific to the size.
After choosing the size, the Parts and Price table will populate below the chosen size.
I will manually insert the amount of items I needed for each part
This will calculate the total from the price*quantity, and then sum all the totals.
<tbody>
</tbody>
EXAMPLE
<tbody>
</tbody>
I have looked and tried to use the vlookup, hlookup functions and I am unable to get anything started.
I would like to be able to choose a Size from a drop down list, that will autopopulate 1 of 2 lists of products and prices. The parts are specific to the size.
After choosing the size, the Parts and Price table will populate below the chosen size.
I will manually insert the amount of items I needed for each part
This will calculate the total from the price*quantity, and then sum all the totals.
SIZES | ||||||||
PARTS | 2-10M | 2-15M | 4-10M | 4-15M | 5-10M | 5-15M | 7-10M | 7-15M |
Gate FC (Manual) | 600 | 600 | 800 | x | x | x | x | x |
Gate (Hyd.) | 600 | 600 | 0 | x | x | x | x | x |
Seat Ring FC | 250 | 250 | 425 | x | x | x | x | x |
Seat Ring Seal FC | 10 | 10 | 10 | x | x | x | x | x |
Body Bushing FC | 250 | 250 | 450 | x | x | x | x | x |
Body Bushing Seal FC | 10 | 10 | 10 | x | x | x | x | x |
Retainer Plates FC | 93 | 93 | 250 | x | x | x | x | x |
Operating Stem FC | 650 | 650 | 950 | x | x | x | x | x |
Stem Packing FC | 55 | 55 | 63 | x | x | x | x | x |
Tail Rod | 255 | 255 | 285 | x | x | x | x | x |
Bearing FC | 10 | 10 | 20 | x | x | x | x | x |
Race FC | 10 | 10 | 20 | x | x | x | x | x |
Bonnet Gasket FC | 100 | 100 | 115 | x | x | x | x | x |
Gate | x | x | x | 2000 | 2000 | 2000 | 3000 | 3000 |
Seat | x | x | x | 600 | 600 | 600 | 1220 | 1220 |
Seat Seal (ID - OD) | x | x | x | 55 | 35 | 35 | 55 | 55 |
Operating Stem | x | x | x | 1400 | 1400 | 1400 | 2100 | 2100 |
Tail Rod | x | x | x | 1000 | 1000 | 1000 | 1600 | 1600 |
Stem Packing | x | x | x | 220 | 150 | 220 | 220 | 220 |
Hydraulic Stem | x | x | x | 2000 | 2000 | 3100 | 3100 | 3100 |
Retainer Plate | x | x | x | 0 | 0 | 0 | 785 | 785 |
Bonnet Gasket | x | x | x | 265 | 150 | 265 | 501 | 501 |
<tbody>
</tbody>
EXAMPLE
(SIZE) 7-15M | |||
Part | Price | Qty | Total |
Gate | 3000 | ||
Seat | 1220 | ||
Seat Seal (ID - OD) | 55 | ||
Operating Stem | 2100 | ||
Tail Rod | 1600 | ||
Stem Packing | 220 | ||
Hydraulic Stem | 3100 | ||
Retainer Plate | 785 | ||
Bonnet Gasket | 501 | ||
TOTAL: |
<tbody>
</tbody>