How to get Cell Reference value with Header Name In Excel

Hi Guys,

Help me in fetching the Cell reference value from column Header Name.cell

Eg- second Column is having Header name “City”, and Cell reference value is “B1”.
so helping me in getting “B1” from “City” header name.

First goto b1 cell and right click
click Define Name
click Ok
Go type city and hit enter then active cell will be b1

Can you give solution Backend not frontend…?