Mar 09 2022 09:34 AM
Hello,
I would like to assign a different value to each item of a drop down list, so that when I select a different item it would change the final value.
Right now I am using a basic "=F15*12" type formula, but I would like that numerical value to change with a drop down list I have in column D.
I have different sized packaging with different weights.
6x1 = 12
5x3 = 33
12x1 = 25
etc
Can anyone help solve this for me? Thank you so much in advance!
Mar 09 2022 10:46 PM
@JustinSchenck Perhaps the attached workbook will get you started. I have use a small lookup table (named "Sizes"), part of which populates the dropdown in column D and is used by VLOOKUP to find the weight. If you are on a recent Excel version, you might want to look into XLOOKUP as well.