Oct 06 2021 10:15 AM
Dear Excel-Users
I need your advice about referring to a chosen element from a dropdown list.
For example: in "A1" there is dropdown list from which I choose an element. The element that I had chosen should multiple "B1" with 3. But if I would chosse an other that would multiply with 4.
My question is that how can I refer to to that changable dropdown element,since Excel does not recognize it.
Oct 06 2021 10:26 AM
Perhaps a VLOOKUP formula, but you should provide much more detailed information, and preferably attach a sample workbook.
Oct 06 2021 12:32 PM
@Hans Vogelaar The problem is that Vlookup (like other functions) simply dont recognize the elements which are in the dropdown list. I could send a picture with an example,but my experience is that if I send one,that would confuse everything.
Oct 06 2021 01:11 PM
SolutionAttaching a sample workbook without sensitive date is your best option.
Oct 07 2021 06:21 AM - edited Oct 07 2021 06:34 AM
You are right,here is an example. If I choose Steel its give 50 for the price, and if I choose the cube shape it will give 5 for the additional cost,which is 55 in total. (In reality I did not referred to steel or the cube just wrote these numbers to cell and it look like that there is a connection between them,its look like that they are depending on each other,while actually they dont.) What I want is that to create an option to the drop down list where I could choose Wood instead of Steel and that would change the material price to 40,and 4 for the additional cost,hich would be 44 in total. Hope you can understand by now.
Oct 07 2021 09:05 AM
That is a screenshot of a worksheet, not a workbook.
You'd need to create a lookup list with the various options and their prices.
Oct 06 2021 01:11 PM
SolutionAttaching a sample workbook without sensitive date is your best option.