Forum Discussion
Solved
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...
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
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)