Forum Discussion

annibe11e's avatar
annibe11e
Copper Contributor
Oct 30, 2019

Enter value, return range or list?

I'm wondering if there's a way to return a drop down list dependent on the value in another cell. For example, if I entered an inventory item in A1, I'd like to then select from a list of colors that item is available in in B1. 

 

1 Reply

  • PReagan's avatar
    PReagan
    Bronze Contributor

    Hello annibe11e,

     

    Maybe some alternate version of the following would work for your situation:

    https://trumpexcel.com/dependent-drop-down-list-in-excel/