Drop down List

V

vibhas

Hello,

I want to create a drop down list of zones 1-10 on Cell A . If th
user select zone 1 the value on Cell B should return as 10 and if the
select zone 2 then 20 and so on for zoen 10 as 100. Could this b
done?

Thanks,
Vibha Sharm
 
J

JH

You can set up a list of values using data validation in cell A, then in Cell
B, enter a formula like "=A1 * 10"

Hope this helps!
 
Top