I have a worksheet with a dropdown box of discount price codes and another
with list prices. I need another column that would automatically figure the
discount when a certain price code is selected.

For example:

Column a column b column c
List price price code new price
1000 a 900
(a=10%)

Any and all help is greatly appreciated.

Thanks!