Forum Discussion
Referring to dropdown list element with "IF" function
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.
Attaching a sample workbook without sensitive date is your best option.
5 Replies
Perhaps a VLOOKUP formula, but you should provide much more detailed information, and preferably attach a sample workbook.
HansVogelaar 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.
Attaching a sample workbook without sensitive date is your best option.
