Indirect?

[ksnapp]

Can I use Indirect with reference to other pages? If so How?

Thank You

 

[green78]

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

 

[GerryK]

Not sure of your intent but here is a working example's
syntax,
=IF(Sheet1!G1="","",INDIRECT("Sheet1!C"&Sheet1!G1))

 

[Bob Phillips]

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)