If Function for Drop Down

Karl86

Hi Im looking for a formula in my sheet where if i select a drop down in one column it will give me a selection of drop downs in another column

eg column 1 - if Commerce is selected

column 2 - commerce, short breaks (drop downs) only

eg column 1 - if guest is selected

eg column 2 - guest, guest data drop downs only

thanks

VBAGuru

On a sheet, there is not a way to do this. The most similar option for sheets would be using Data Shuttle, but this is not nearly as dynamic as what you are looking for. The closest option I can think of is using Forms and building in the Logic that way. You would need a separate column for each options except your first. It is these extra columns that you would put all of the separated choices and use the forms logic to open.

Down side is that your data is no longer contained to two columns, but would be in multiple. You could add "helper" columns to get it all back into two though. It would just take some setup and formulas.