Hello,
I am using INDIRECT to read text off a cell, into a formula that shows the value of a cell from another sheet.
=INDIRECT("'"&$B$8&"'!H11")
B8 being the other sheet name.
The problem I am having is that when I drag this formula down the column, the target cell reference(H11) doesn't change like it would if the formula was ='other sheet'!H11
Thanks.
Bookmarks