Hi All,
I have been looking for a few days now and can't seem to find a formula to works this one out.
I have a macro enabled sheet and a formula which generates a list of sheets on the Main Sheet, beside that I reference data that I would like to return a value based on the sheet name.
Column A contains all the Sheet Names, B the data I want it to return. For simplicity I have named the sheets by number.
I would essentially like cell B# to look at the data in Cell A# of the Main Page and match that with the Sheet name, then return Cell B4 of that sheet.
If an example is needed then I can extract a blank version of the document for reference.
Thank you in advance
Bookmarks