Build excel formula using field values as text in the formula

[Guest]

Instead of writing the formula to add two cells as say, B4+B38 in Excel, I
want to build the formula using the contents on another cell, e.g.
I've tried B4+"B"&(TEXT(B13,0)).

The value of B13 is 38, therefore +"B"&(TEXT(B13,0)) equates to B38. That
works fine. But if I combine it with B4 as above, the result is #VALUE!
Any ideas on how I could get around this?

 

[Guest]

You need INDIRECT, use:
=B4+INDIRECT("B"&B13)
where B13 contains: 38

 

[Guest]

You missed an "INDIRECT" Function in your formula

=B4+INDIRECT("B"&(TEXT(B13,0)))