Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 12-19-2005, 04:20 PM
Novice
 
Join Date: Dec 2005
Posts: 1
Browett
Default Drop Down Lists


My problem is as follows.
I am currently developing a spread sheet for my sales guys where I want them to be able to select a drop down arrow and choose an option. That part I have figured out no problem. I want the option they then pick (in one column) to have a $value show up in the next column adjacent to their selection. I have been able to get around this by using the if function, which is unfortunately only good for 2 selections.

My question is, how can I have multiple options in my drop down, and have the correct value show up? They will never be the same values.

Also, I am creating all of my options and values on a seperate sheet, with my main sheet being the sales sheet, this way everything can be hidden.

Thx
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Numbered lists in Word, a permanent headache nospamforyou Word 0 10-09-2008 09:13 AM
file -> open -> drop down arrow docsworld Office 1 05-03-2008 08:49 PM
Drop down box in a cell Grapejuice Excel 0 10-22-2007 07:40 PM
Word Forms : Dropdown lists wferaera45 Word 0 04-06-2006 03:02 AM


All times are GMT -7. The time now is 01:26 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft