Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Thread Tools Display Modes
Old 12-19-2005, 04:20 PM
Browett Browett is offline
Drop Down Lists
Join Date: Dec 2005
Posts: 1
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.

Reply With Quote

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 02:14 PM.

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