I need a formula for this.

New Contributor

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.

2 Replies
best response confirmed by igesanmi (New Contributor)


You can use the INDIRECT function. Enter the following formula in B4:




We concatenate the fixed column letter A as a literal string "A" with the dynamic row number in G5.

Thank you, this worked perfectly.