SOLVED

Referring to dropdown list element with "IF" function

%3CLINGO-SUB%20id%3D%22lingo-sub-2818672%22%20slang%3D%22en-US%22%3EReferring%20to%20dropdown%20list%20element%20with%20%22IF%22%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2818672%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20Excel-Users%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20your%20advice%20about%20referring%20to%20a%20chosen%20element%20from%20a%20dropdown%20list.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20example%3A%20in%20%22A1%22%20there%20is%20dropdown%20list%20from%20which%20I%20choose%20an%20element.%20The%20element%26nbsp%3B%20that%20I%20had%20chosen%20should%20multiple%20%22B1%22%20with%203.%20But%20if%20I%20would%20chosse%20an%20other%20that%20would%20multiply%20with%204.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20question%20is%20that%20how%20can%20I%20refer%20to%20to%20that%20changable%20dropdown%20element%2Csince%20Excel%20does%20not%20recognize%20it.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2818672%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2819304%22%20slang%3D%22en-US%22%3ERe%3A%20Referring%20to%20dropdown%20list%20element%20with%20%22IF%22%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2819304%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3BThe%20problem%20is%20that%20Vlookup%20(like%20other%20functions)%20simply%20dont%20recognize%20the%20elements%20which%20are%20in%20the%20dropdown%20list.%20I%20could%20send%20a%20picture%20with%20an%20example%2Cbut%20my%20experience%20is%20that%20if%20I%20send%20one%2Cthat%20would%20confuse%20everything.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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. 

5 Replies

@Fredblack64544 

Perhaps a VLOOKUP formula, but you should provide much more detailed information, and preferably attach a sample workbook.

@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. 

best response confirmed by Fredblack64544 (New Contributor)
Solution

@Fredblack64544 

Attaching a sample workbook without sensitive date is your best option.

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.

@Fredblack64544 

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.