how do i use a formula inside of a cell reference in Excel

M

mh

I need to use a formula inside of a cell reference. For instance, if I was
referencing D3, instead of row 3 I need to calculate it like D(formula). The
formula will be dependent on logged data that I receive.
 
M

Max

Maybe INDIRECT(..)

A simple example:

If cell D4 contains the value 9
and B1 has a formula which computes to say: 2

Putting in A1:=INDIRECT("D"&B1*2)
will return the equivalent of : =D4
which returns 9

If B1 re-computes to say: 3
A1 will then return the value in D6 (instead of D4)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula not working properly 2
Excel - Wich Function should I use? 1
Using <= in countifs statement 1
Count Number of Unique Cells That Don't Have Certain Characters 0
Display weeks from a Milestone 0
Converting a number into a cell reference 2
Excel help needed: Skipping cell without skipping cell reference 1
Referencing an External Cell 1

Top