# Thread: Get Cell Reference From Cell Address ? Thanks: 0 Likes: 0

1. ## Get Cell Reference From Cell Address ?

Hi dear forum members,

Is there a formula that would take a cell address and return the corresponding cell reference so I can then use this reference as an argument in other fonctions such as INDEX etc... ?

Looking for a Non-UDF solution.

Regards.

2. ## Re: Get Cell Reference From Cell Address ?

Hi Jaafar,

Take a look at INDIRECT() - for example.

Excel 2013/2016
ABC
1AA1:A100C
2B
3C
4D
5E
6F

Sheet1

Worksheet Formulas
CellFormula
C1=INDEX(INDIRECT(B1),3)

3. ## Re: Get Cell Reference From Cell Address ?

Originally Posted by FormR
Hi Jaafar,

Take a look at INDIRECT() - for example.
Thanks for the quick response FormR,

The INDIRECT function takes a cell reference not a cell address.

I need to pass a literal address string something like "B1".

4. ## Re: Get Cell Reference From Cell Address ?

Originally Posted by Jaafar Tribak
The INDIRECT function takes a cell reference not a cell address
Hi Jaafar, no - it takes a string and returns a range reference.

In my example I put the string in a cell, but you don't need to do that, for example.

Excel 2013/2016
AB
1AC
2B
3C
4D
5E
6F

Sheet1

Worksheet Formulas
CellFormula
B1=INDEX(INDIRECT("A1:A100"),3)

5. ## Re: Get Cell Reference From Cell Address ?

You are right.

The cell reference resolves to a string in the end... I am trying to incorporate the INDIRECT(), ADDRESS() AND CELL("address") functions into a larger formula... I'll get back if I get stuck.

Thank you very much for your help.