Cell To Sheet Name Reference

Important Notice


Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

    I am trying to create a summary sheet that will look on certain worksheets based on on a cell.


    For example:
    If cell E1 equals 10-Oct-30 then it will pull data from tab 'End Oct 30'


    I would prefer to use a formula for this calculations. to aid in another persons potential use. A custom function would be OK.

    [SIZE=2]I should change my name to STUMBED![/SIZE]

    Re: Create Cell To Sheetname Reference


    Hi


    Make sure E1 holds the value "End Oct 30" or whatever the sheet is actually named - it makes things far simpler. You can then use INDIRECT to pull in values from the referenced sheet in E1 eg:


    =INDIRECT("'" & $E$1 & "'!A1")


    to pull in the value in cell A1 of the sheet referred to in E1.


    Richard

    Re: Create Cell To Sheetname Reference


    Perfect,


    I was working on a similiar formula I found doing a search, but for some reason that one didnt click like your did. Much Appreciated.

    [SIZE=2]I should change my name to STUMBED![/SIZE]

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login