Find Out a Value in a Range and column Name Required

[majidsiddique]

Hi All,
hope you are good, i need a help to find out city name, i export a file from system. in column G manually put but i want it by formula in column H city name and i required column name in column I. i hope you understand my point.

see the attached file.

Thanks

[bebo021999]

City:

Please Login or Register  to view this content.

Column:

Please Login or Register  to view this content.

[majidsiddique]

Thanks bebo021999:
its perfect.
Thanks a lot