[Solved] List that defines values for second list

[kruizengad]

Not sure if this has been covered or not, but I could not find it with searching. If it has been covered, please link.

I want to make a drop-down list in CALC where the selection determines the selections available in a second drop-down.

Here is what I doing. have a list of cities, their corresponding counties, and then their corresponding municipalities. Then the list tells me what Ultiliy companies that location uses.

I want to select the city from a drop-down menu, then select the corresponding counties in that city, then have it fill in the municipality and utility companies to the right for those values

I have the drop-down menus on sheet 1 and all the information on sheet 2. Any help or guidance will be appreciated. I uploaded the file just in case anyone wants to see what exactly I am dealing with.

Utility Providers List for Michigan.ods

(33.73 KiB) Downloaded 148 times

Thank you in advance.

[Zizi64]

viewtopic.php?f=9&t=85196
viewtopic.php?f=9&t=93796

[kruizengad]

Thank you, that second link does what I need to do with a bit of reworking to the source data.