I have multiple lists in an excel worksheet. I am trying to make it so I can choose from multiple lists based on the list chosen in an adjacent field.
For example, in one cell, I've got a pull down list of all the lists in the worksheet.
When I choose "list A" I want the cell next to it to offer a pull down that shows all the choices in that list.
So, some kind of formula that is an "=list" formula.
Does this exist?