Change table data based on multiple dependent drop-down selections

[ravecake]

Hi,

I have a data table of financial securities, each item(row) corresponding to a certain country/region of issuance.

I would like to have that table filtered automatically to show only those securities issued from a specific country and region selected from a dependent drop-down list (Region -> Country).

e.g. If I select Europe on the first drop down then the table should only show those securities issued in Europe. From there, if I select United Kingdom (or Germany, France, etc.) on the second/dependent drop down the table should filter even further to show only those securities issued in the UK. This should ideally be done automatically without having to manually refresh the table.

I am aware of how to create dependent drop-downs but unable to have a table of data filtered according to those selections.

This would be on Excel 2016 so I am unable to use UNIQUE or FILTER functions.

Doesn't strictly need to be done using data validation if combo boxes can be used (or any other alternative method).

Is this possible? Would greatly appreciate any advice or suggestions.

Many thanks in advance!!!

 

[ravecake]

Bump!

 

[Beneindias]

You need to create a table for each country, with table and heather named after that country and having all the securities.

Then you need to use data validation and use the INDIRECT function.

For example, if in cell A2 you choose EUROPE, then in cell A3 you need to have a data validation like: =INDIRECT(A2)