Forum Discussion
Auto select drop down menu item based on a cell value
Hi all,
Is there a way to populate or auto-select a drop-down menu item in one cell based on another cell's value?
eg. The difference between two other cells is a positive value, so I would like the drop down menu in another cell to select one value, or a different one if the difference is a negative value
In the attached file, the formula in the source box of the drop-down list in I9 is:
=IF(((H9="")+(H9=0))*(I9=""),Codes,IF((H9>0)*(I9=""),PosCode,IF((H9<0)*(I9=""),NegCode,"")))
Note the following defined names therein:
Name Formula Codes =Sheet1!$A$2:$A$14 NegCode =Sheet1!$A$4 PosCode =Sheet1!$A$9
15 Replies
Hello Everyone
I am privileged to join this amazing community of Excel users today only.
here is a tutorial I created sometime ago on dependent drop lists:
https://www.youtube.com/watch?v=0MuQfUJbycQ
Hope this helps
Thanks
Nabil Mourad
- If you’re referring to alternative lists, you may enter a formula similar to this in the source box:
=IF(A2>0,
List1,
List2)- Not sure if I follow you Twifoo. What I have is a drop-down menu in one cell, that is necessary so that the user can make other selections, but within the selections available in that drop-down menu, under certain conditions, it would make things a lot more user friendly, if the drop-down menu would auto-select two of its items if the value of another cell were positive or negative.
- Can you please attach a sample file to illustrate what you want to achieve?
rmmwilgYou may use IF function instead of the drop down, similar as the following:
=IF(A2>0,Value 1,Value2)
As A2 is the cell of the positive or negative value, and the formula is written instead of the drop down
- Hi Ayman, the challenge is that I have to retain the drop down menu, since it has other uses in addition to this 'autofill' request. What I'm hoping for is that there's an ability to make a drop-down menu auto select a certain item based on another cell's value (positive or negative)
