Drop down menu, convert letter to number

[MrEnigma]

Hi guys

I have a drop down menu using data validation and the values are B,C,D
I want to keep the letter in a cell, but make each one become number, so B=5, C=10, D=20
I have another dropo down menu that contains 6,10,16

What I require is that once the 2 drop down menus have 'values selected' I need to multiply the 2 cells together

so for example

If B and 6 was selected, I require the 3rd cell to be 5*6
so what is the formula?

[XOR LX]

Hi,

Assuming that the letter and number drop-down menus are in cells A1 and B1 respectively, enter this formula in C1:

=LOOKUP(A1,{"B","C","D"},{5,10,20})*B1

Regards