lordhelmet
12-14-2016, 05:15 AM
I've been plugging away at this darn INDIRECT formula for days now and can't seem to get where I need to.
I need cells in the Employee sheet to reference cells in the Times sheet that is horizontally listed. The Employee sheet has reference cells like. A for sheet name. B for row reference. C for column.
A B C
1Employee 2 2
So Employee sheet needs to reference the correct row, and each cell with the indirect formula needs to column increment +1 to return next value in the Time sheet. Hope that makes sense
=INDIRECT("'"& $H$1 &"'!"&CELL("address",B2))
The above formula works ok but has to be dragged over multiple cells.
This seems counter intuitive if working with multiple sheets, which I am.
Each sheet should have the same INDIRECT formulas but use different reference cells right?
I need cells in the Employee sheet to reference cells in the Times sheet that is horizontally listed. The Employee sheet has reference cells like. A for sheet name. B for row reference. C for column.
A B C
1Employee 2 2
So Employee sheet needs to reference the correct row, and each cell with the indirect formula needs to column increment +1 to return next value in the Time sheet. Hope that makes sense
=INDIRECT("'"& $H$1 &"'!"&CELL("address",B2))
The above formula works ok but has to be dragged over multiple cells.
This seems counter intuitive if working with multiple sheets, which I am.
Each sheet should have the same INDIRECT formulas but use different reference cells right?