How to set up cascading filters (relevant values) in Workbooks?

If I have a Country listbox and a City listbox, I want to be able to pick a country and have the City listbox show only the cities in that country. That is called cascading filters (aka “use relevant values”).

How to set up cascading filters (relevant values) in Workbooks?

Let’s say you have a Country listbox and a City listbox. Country listbox gets its values from “List of Countries” table element, and City - from the “List of Cities by Country” table element.

If you set the Target of the Country listbox to be the “List of Cities by Country” table element, then for every selection of the Country, the City listbox will show only the Cities, related to that country.

Note that the “List of Cities by Country” table element must have a column for [City] and a column for [Country].

1 Like