Find the heading matching with range

I have a Meeting Place and Cities Table(too large).
An example attached as a file and explained waht is wanted.

Thanks in advance for any reply and help.
Regards,
turist

Try this:

FindHeading.xlsm

Please Login or Register  to view this content.

Originally Posted by Joakim N

Try this:

Attachment 312908

Please Login or Register  to view this content.

Thanks a lot.
Maybe find a solution with regular function or formula (NOT by macro)
Regards