How to get Cell Reference value with Header Name In Excel


#1

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.


#2

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


#3

Can you give solution Backend not frontend…?