Lists

**Ayoub99k** · 10-10-2015, 12:53 PM

I made a list. When I click on a cell, a drop down list appears with the numbers 1,2,3 and 4.

What I want to do is. If a cell = the value 500000 then what appears in the list is say for example 2,3,4 and if the value in a cell = the value 300000 then the values that appear in the drop down list is 1,2,3,4.

Any way I can do this?

**FDibbins** · 10-10-2015, 03:19 PM

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(note: this change is not optional

)

Also, dropdown lists are manually selected. If you want the cell contents to change, based on some other value, use vlookup or IF (if there are only a few options)