Forum Discussion
I need a formula for this.
I have an document with let's say value of 2 in cell G5 and I want want to reference cell A2 into cell B4 without typing the 2 but using the value in G5 since that is already 2. So basically I need something like this B4 =A(G5) if there is anything like that.
You can use the INDIRECT function. Enter the following formula in B4:
=INDIRECT("A"&G5)
We concatenate the fixed column letter A as a literal string "A" with the dynamic row number in G5.
You can use the INDIRECT function. Enter the following formula in B4:
=INDIRECT("A"&G5)
We concatenate the fixed column letter A as a literal string "A" with the dynamic row number in G5.
- Thank you, this worked perfectly.
