photologue
New Member
- Joined
- Jun 12, 2014
- Messages
- 13
Good morning,
I have the following lookup table ...
<colgroup><col><col><col span="3"><col></colgroup><tbody>
</tbody>
I then have two drop down lists for selecting the product (column G) and the build stage (column F) (prints, material .... packaging).
I want to return the relevant cost based on BOTH product and build stage criteria and know that my current method is not best practice.
Can anyone please point me in the right direction ?
Many thanks in advance
I have the following lookup table ...
Product | Prints | Material | Prinited | Tin | Packaging |
LuggageTags | 0.26 | 0.95 | 1.21 | 0.00 | 0.36 |
FridgeMagnets | 0.22 | 0.69 | 0.91 | 0.00 | 0.39 |
Keyring | 0.22 | 0.90 | 1.12 | 0.00 | 0.21 |
Coaster | 0.11 | 0.48 | 0.59 | 0.00 | 0.08 |
ToteBag | 0.89 | 3.68 | 4.57 | 0.00 | 0.76 |
MouseMat | 0.21 | 0.79 | 1.00 | 0.00 | 0.26 |
Jigsaw | 0.45 | 1.20 | 1.65 | 0.83 | 0.25 |
WhiteMug11oz | 0.25 | 0.95 | 1.20 | 0.00 | 0.30 |
BlackMug11oz | 0.31 | 1.27 | 1.58 | 0.00 | 0.30 |
WhiteMug15oz | 0.31 | 1.15 | 1.46 | 0.00 | 0.40 |
Photopanel7x5 | 0.75 | 3.50 | 4.25 | 0.00 | 0.24 |
Photopanel10x8 | 1.06 | 4.95 | 6.01 | 0.00 | 0.36 |
<colgroup><col><col><col span="3"><col></colgroup><tbody>
</tbody>
I then have two drop down lists for selecting the product (column G) and the build stage (column F) (prints, material .... packaging).
I want to return the relevant cost based on BOTH product and build stage criteria and know that my current method is not best practice.
Can anyone please point me in the right direction ?
Many thanks in advance