Indirect?

  • Thread starter Thread starter ksnapp
  • Start date Start date
Yes, you can, you just have to follow the required syntax:

Example:

in "Sheet2" --> Type in cell A1 --> "5"

Then in "Sheet1" in cell B1 ---> "Sheet2!A1" (without quotas)

Now in any cell in "Sheet1" type "=Indirect(B1)"

The result should be "5"... taken from cell A1 in "Sheet2"

You can even link to other files, you just have to stick to the syntax
 
Not sure of your intent but here is a working example's
syntax,
=IF(Sheet1!G1="","",INDIRECT("Sheet1!C"&Sheet1!G1))
 
INDIRECT basically evaluates the argument, so as long as you construct a
valid expression, you can use any form.

So you can use
=INDIRECT(A1)
=SUM(INDIRECT("A1:A2"))
=INDIRECT("Sheet1!A"&A1)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top