Dynamic Cells

[mmartens12 via OfficeKB.com]

I want to evaluate a single row at a time in a set of formulas.

How would I take a simple equation like =D6 + D12 and make the 12 in D12
dynamic?

Example =D6 + D&(C3) when C3 = 12


What would be the correct syntax to do this?

 

[CurlyDave]

I want to evaluate a single row at a time in a set of formulas.

How would I take a simple equation like =D6 + D12 and make the 12 in D12
dynamic?

Example   =D6 + D&(C3)    when C3 = 12

What would be the correct syntax to do this?

=SUM(INDIRECT(D6&""&C12))

 

[T. Valko]

One way:

=D6+INDEX(D,C3)

If C3 is an empty cell you'll get an error.

 

[Shane Devenshire]

Hi,

Here are two other solutions:

=D6+INDIRECT("D"&C3)

=D6+OFFSET(D1,C3-1,)

And for a little bit of interest if anyone reads this

=SUM(SUM(INDIRECT("D"&{6,12})))

note that the last formula will not return the correct result with only one
SUM, nor if it is array entered with one sum.

 

[mmartens12 via OfficeKB.com]

Thank You!

One way:

=D6+INDEX(D,C3)

If C3 is an empty cell you'll get an error.

I want to evaluate a single row at a time in a set of formulas.

[quoted text clipped - 4 lines]

What would be the correct syntax to do this?

 

[T. Valko]

You're welcome!

--
Biff
Microsoft Excel MVP

Thank You!

One way:

=D6+INDEX(D,C3)

If C3 is an empty cell you'll get an error.

I want to evaluate a single row at a time in a set of formulas.

[quoted text clipped - 4 lines]

What would be the correct syntax to do this?