SOLVED

I need a formula for this.

Copper Contributor

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.

2 Replies
best response confirmed by igesanmi (Copper Contributor)
Solution

Re: I need a formula for this.

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.

Re: I need a formula for this.

Thank you, this worked perfectly.
1 best response

Accepted Solutions
best response confirmed by igesanmi (Copper Contributor)
Solution

Re: I need a formula for this.

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.