Using drop down lists to retrieve group of cells

I am not sure if this is the proper place to ask or if I will be able to explain it enough. I am trying to use 2 different criteria both from a separate drop down list and return a specific group of cells. For instance the first drop down would be a list of counties then the second would be a list of cities within that county. I have another tab listing all the counties and within that group of cells the cities then 5 or 6 numbers for each city. I would like the user to be able to choose a county from the first drop down then choose an appropriate city from the second drop down and have it return only the line of numbers for that city displaying it just underneath the user input instead of them having to scroll thru the entire list on the second tab. I can make the drop down lists and feel there should be some way to do this but don't know what function to turn to.

Thanks
Randy

Hi, welcome to the forum

There are a few different ways of doing this, but it would help if you could upload a small (clean) sample of what you are working with, and what your expected outcome would look like.

Yup, got the file thanks.

I understand that this is a dummy file, but this will give youy what you want...
=INDEX(C$1:C$15,MATCH($K$13,$A$1:$A$15,0)+MATCH($K$14,$B$1:$B$5,0)-1)

However, it is based on all counties having the same number of Cities

Here is a possibility (amongst many) that might satisfy you. If you require more countries, add a column to the countries table. Cities for added countries would be added following the example of how the cities are arranged for each country in the example.