SOLVED

Creating a Cell label reference from a formula

Occasional Visitor

Not sure is I can explain this correctly, but here goes.

Pilgrim70_0-1671185074205.png

E2 has been labled as _OC7001 and E3 as _OC7002

 

B1 has the entry _OC7001 but I am wanting to create this off the value in column A. I tried to achieve this in B2 by using =CONCAT("=_",A3) but that returns the text =_OC7002 and not the value of the cell reference by _OC7002.

 

How do I acheive this?

1 Reply
best response confirmed by Pilgrim70 (Occasional Visitor)
Solution

@Pilgrim70 Use the INDIRECT function like this:

In B2: =INDIRECT(A2)