=A1*INDIRECT("Sheet2!A"&ROW(A1))


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"john" wrote in message
oups.com...
wrote:
Assuming that sheet2!a1 contains the cell reference, then the formula
is wrong - it should be

=A1*INDIRECT(Sheet2!a1)

No, I meant the question exactly as I asked it.

sheet2!a1 contains a value, not a formula or cell reference. The
purpose of the INDIRECT function here is to let me rearrange cells in
sheet2 without affecting formulas in sheet1.

In any case, removing the quotes doesn't work.

--
John Uebersax