Hello,
I want to create a drop down list of zones 1-10 on Cell A . If the
user select zone 1 the value on Cell B should return as 10 and if they
select zone 2 then 20 and so on for zoen 10 as 100. Could this be
done?
Thanks,
Vibha Sharma
--
vibhas
------------------------------------------------------------------------
vibhas's Profile:
http://www.excelforum.com/member.php...fo&userid=7483
View this thread:
http://www.excelforum.com/showthread...hreadid=399545