There seem to be many posts related to these two topics taken together, but I haven't been able to find one that solves my problem:
On Sheet 2, I have a data table with 4 columns. Column A contains industry (4 unique listings) and Column B contains clients (5 unique listings per industry).
On Sheet 1, I would like to have cell A1 give me a dropdown of the 4 industries and cell B1 give me a dropdown of the clients for the respective industry chosen in A1.
One catch: the data source is dynamic; new entries can be added at any point (assume the industries will remain constant but new entries with new clients can be added). Basically, I need the dropdown in B1 to update with the new clients entered in the data source
My thought was something like a vlookup in the data validation source (using list) for B1 that does a lookup of the value in A1 and returns the list of all corresponding clients in the data source.
Any ideas?
On Sheet 2, I have a data table with 4 columns. Column A contains industry (4 unique listings) and Column B contains clients (5 unique listings per industry).
On Sheet 1, I would like to have cell A1 give me a dropdown of the 4 industries and cell B1 give me a dropdown of the clients for the respective industry chosen in A1.
One catch: the data source is dynamic; new entries can be added at any point (assume the industries will remain constant but new entries with new clients can be added). Basically, I need the dropdown in B1 to update with the new clients entered in the data source
My thought was something like a vlookup in the data validation source (using list) for B1 that does a lookup of the value in A1 and returns the list of all corresponding clients in the data source.
Any ideas?
