Forum Discussion

rmmwilg's avatar
rmmwilg
Brass Contributor
Jun 20, 2019
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...
excel
Macros and VBA
office 365
  • Twifoo's avatar
    Twifoo
    Jun 22, 2019

    rmmwilg 

    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: 

    NameFormula
    Codes=Sheet1!$A$2:$A$14
    NegCode=Sheet1!$A$4
    PosCode=Sheet1!$A$9

Resources