conditoin ?

[guismo30]

Good morning everyoneI am new in Excel and need you help. I have search on Google, your site but could not find anything that could really help
I have a drop down menu in the cell B21, depending on the value choosen, the cell B64 will nee to show a result.
My drop down values on cell B21 are

• IA - Industrial
• SA - Special Market
• IC - Industrial X
• SC - Special Market X
• 03 - ZMKT & ZLIT
• 03 - ZDIE

If IA or IC is choosen, I will need a code "1201010" to appear in cell B64 If SA or SC is choosen, I will need a code "1301010" to appear in cell B64 If 03 - ZMKT & ZLIT is choosen I will need the code "1201030" to appear in cell B64 If 03 - ZDIE is choosen I will need the code "1201010" to appear in cell B64
I do not know how works the if etc.. reason why I ask your help

I hope this explanation is good enough (sorry I am french speaker)
Thank you for your help
Pierre

 

[NBVC]

Assuming you have the list for your drop down somewhere in the sheet you can use a VLOOKUP where you would have the corresponding codes listed next to the list items.

e.g.

=VLOOKUP(B21,$X$2:$Y$7,2,0)

where X2:Y7 contains your dropdown list source and respective codes to extract next to them.

 

[guismo30]

Assuming you have the list for your drop down somewhere in the sheet you can use a VLOOKUP where you would have the corresponding codes listed next to the list items.

e.g.

=VLOOKUP(B21,$X$2:$Y$7,2,0)

where X2:Y7 contains your dropdown list source and respective codes to extract next to them.

thanks I will try now