Hello group. I am searching for a solution where multiple drop-down lists are dependent on the same reference/source.
For example: the source is list of cities. Depending on the city selected, I want to determine 3 more lists: restaurants, hotels, museums. These lists must be dependent on the city selected but not dependent on each other in cascade model.
I tried with INDIRECT function but it allows me to reference only one dependent list(for example restaurants) to one source (cities). Probably in a combination with another function I would be able to reference more that one dependent list to the same source.