Convert reference to a cell to showing a value of that cell with a formula

[2Took]

If I have a cell with a formula that returns reference to a cell address (e.g. formula returns B20), how do I get it to show the contents/value of what is in that cell (B20) instead of just showing literally B20?

For clarity: not talking about copy & paste values.

 

[Joe4]

If the formula truly just returns "B20", then just surround it in INDIRECT, i.e.
=INDIRECT(formula)

 

[2Took]

If the formula truly just returns "B20", then just surround it in INDIRECT, i.e.
=INDIRECT(formula)

For some reason when I try to use =CONCATENATE or & method to add contents of another cell with INDIRECT, it only brings that other cell and nothing from the INDIRECT cell...
Any idea?

 

[Joe4]

For some reason when I try to use =CONCATENATE or & method to add contents of another cell with INDIRECT, it only brings that other cell and nothing from the INDIRECT cell...
Any idea?

I am not sure what you mean.
Please show me exactly how you are trying to use it.

 

[2Took]

I am not sure what you mean.
Please show me exactly how you are trying to use it.

=INDIRECT(formula) works by itself, but when I am trying to add header cell value like this:

=H13 & INDIRECT(formula)
or
=CONCATENATE(H13, INDIRECT(formula))

It only populates the value from H13

 

[Joe4]

Seems to work just fine for me.
I suspect you have other issues going on.