Results 1 to 4 of 4

Cell value as part of a reference to another sheet

Threaded View

  1. #1
    Registered User
    Join Date
    10-17-2011
    Location
    Seattle, USA
    MS-Off Ver
    Excel 2007
    Posts
    79

    Cell value as part of a reference to another sheet

    Hi all,

    Despite the search feature, I have not been able to find a solution to my problem which is most certainly an easy one. I put the blame on my inability to find the correct keywords.

    My goal is to create a sheet with formulas that I will keep as a model; I will duplicate and rename this model before using it.
    In this renamed sheet, let's call it "Result1", I will enter a string "Data1" in A1. This value in A1 will actually be the name of another existing sheet.

    What I want to achieve is that the formulas in "Result1" will look for the data they need in the sheet named as in A1 (i.e. "Data1")
    Data1
    =SheetNameAsInA1!A2
    The problem is that I have been unable to find the proper syntax for the "SheetNameAsInA1" part.
    If this is not clear, I hope that the example attached will clarify my question.

    Thank you in advance for your help!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Possible to use one cell's VALUE as a part of a REFERENCE in a formula?
    By Jet0L19 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-13-2014, 03:30 PM
  2. [SOLVED] cant get a formula to have one part of my excel sheet reference data for different days.
    By Shellybelly in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 08-19-2013, 12:10 PM
  3. [SOLVED] reference part of cell address from button and part of another cell
    By JJGF in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-24-2012, 04:48 PM
  4. Replies: 1
    Last Post: 12-29-2011, 06:44 PM
  5. Replies: 5
    Last Post: 02-25-2010, 03:51 PM
  6. using a cell reference as part of a formula
    By luca in forum Excel General
    Replies: 1
    Last Post: 10-07-2009, 06:23 AM
  7. How to find sheet in formula by (part) cell reference. use Indirect ???
    By KrisVeen in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-21-2006, 06:38 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1