| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display data from another worksheet
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Display data from another worksheet
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Display data from another worksheet
Another one:
=index(sheet2!d:d,c1) 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? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I display every 5th row of data from a worksheet in a new . | Excel Worksheet Functions | |||
| Display data from multiple worksheets' cells in one worksheet | Excel Worksheet Functions | |||
| how do i filter data on one worksheet and display on another. | Excel Discussion (Misc queries) | |||
| How do I display data in different worksheet in excel | Excel Discussion (Misc queries) | |||
| Macro to search for and display data in another worksheet | Excel Worksheet Functions | |||
Linear Mode
