Hi all,
I have sheet names (same as class names) entered in B2:B22. I want to look cells in each sheet, but don't want to manually enter each in case class names change shortly.
Is there a way for a formula to look in another cell for the sheet name?
i.e. instead of ='ClassA'!D8, it would look in B2 for the value 'ClassA'. so: =B2!B8
Help much appreciated!
Thanks
Luke
Bookmarks