[Solved] Using lists

  • 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?

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!