Drop down List
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 |
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! "vibhas" wrote: 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 |
All times are GMT +1. The time now is 03:45 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com