INDIRECT makes it possible
In Sheet1,
In D476, copied down:
=INDIRECT("'Sheet2'!D"&C476)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,500 Files:362 Subscribers:62
xdemechanik
---
"Don" wrote:
With Sheet1 active and desiring the output of a formula similar to...
=Sheet2!$D$476...
I want to automate the formula so that the value 476 is not hardcoded but
rather obtained from Column C on Sheet1 for every row.
The data I want to display in Sheet1 Column D will always come from Sheet2
Column D. Which cell to choose from in Sheet2 Column D is determined by the
value of Sheet1 C1, C2, C3, etc.
Here's Row 1 of Sheet1 with the formula displayed in D1 (476 hardcoded)...
A B C
D
1 452291 476 =Sheet2!$D$476
I think I'm trying to embed formulas but a) I don't know how and b) I don't
know if it's possible.
Can you help?