hi all, hopefully this is an easy answer for somebody!

what i have is a table of data. with the regions as column headings then all the cities in that region below their correct heading

i.e. (in this example table range would be a1:d6)

region1 region2 region3 region4
city1 city6 city10 city13
city2 city7 city11 city14
city3 city8 city12
city4 city9
city5

then in cell f1 you put a city, then the formula in f2 will match the city to the column and return the heading from row1

so for example
city10 would return region3
city3 would return region1

i would also like if possible for the range to be a table name, and the table to be dynamic so cities could be added if required

hope somebody can help, thanks in advance