Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-19-2005, 04:20 PM
Browett Browett is offline
Novice
Drop Down Lists
 
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
Drop Down Lists 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

Other Forums: Access Forums

All times are GMT -7. The time now is 09:56 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft