cell reference e.g. "=A30" as "=A[formula tha

[willynilly82]

How can I have a formula for a cell reference instead of just a number?

Normally I reference a cell by typing "=A30" (for example). But what I need is the number, or row, to be the result of a formula. e.g.

"=A[result of a formula that equals 30]"

Is this possible? Thanks.

 

[Norie]

I'm not quite sure what you are asking but you could use the INDIRECT worksheet function.

=INDIRECT("A" & B1)

Where B1 has the result of your formula.

 

[willynilly82]

Whoo hoo! That works great. Thanks.

 

[Aladin Akyurek]

Re: cell reference e.g. "=A30" as "=A[formula

How can I have a formula for a cell reference instead of just a number?

Normally I reference a cell by typing "=A30" (for example). But what I need is the number, or row, to be the result of a formula. e.g.

"=A[result of a formula that equals 30]"

Is this possible? Thanks.

=INDEX(A:A,B1)

where B1 houses a row value like 30.

 

[Nimrod]

You can also put the formula directly into the cell , instead of refering to B1


Example of total formula in same cell ...
=INDIRECT("A" & SUM(B1:D1))

ie if cells B1 + C1 + D1 = 25 then your indirect refers to cell A25.