#1
|
|||
|
|||
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 |
|
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 |