I have the following reference table, that i would like to make it as a drop down list that shows like below. When i utilize this drop down list, the cell that is selected should carry the value of 10, or 20, or 30. That way on another cell i can do some mathematical multiplication. Is this possible?
Model Power (Amps) A 10 B 20 C 30 D 40 E 50
Drop Down List that is in Sheet2
Amps (Drop Down List) Voltage Power A-10A 480 4500 B- 20A 480 9600 C-30A 480 14400 D-40A 480 19200 E-50A 480 24000