I have a list of geographic business regions from my company and each region has up to 9 territories. I would like to select one of the regions from a list and when I select that region, have each of its territories populate a table below in separate cells.

For example, region 1001 contains territories 100101, 100102, 100103, 100104, 100105, 100106 and 100107. The territories are in a list separate from the Region names. When I select region 1001 from a list in Cell b2, I want the 7 territories to appear in cells c2 through c8

I think I should use the index/match functions but can't seem to get it to work.

Can someone provide some insight?

Many thanks