+ Reply to Thread
Results 1 to 6 of 6

Reference to another sheet

  1. #1
    Registered User
    Join Date
    06-24-2020
    Location
    Stuttgart, Germany
    MS-Off Ver
    2020
    Posts
    17

    Reference to another sheet

    Hi,
    I have a matrix of values in my first sheet "Tabelle1". In my second sheet "Tabelle2", some underlying function returns a value such as "A4", "B2", "F6", etc. I want to use this value in order to make a cell reference in my second sheet "Tabelle2" to the resprective cell, such as "A4", "B2", "F6" in my first sheet "Tabelle1".
    Attached you can find an example. In "Tabelle2", I want to use the value "A4" in cell A1 to make in cell C1 to cell A4 in sheet "Tabelle1".
    Does anyone has an idea how to do that?
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,740

    Re: Reference to another sheet

    What do you want to see on Tabelle 2?
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    06-24-2020
    Location
    Stuttgart, Germany
    MS-Off Ver
    2020
    Posts
    17

    Re: Reference to another sheet

    In the example above, I would like to see the value from cell Tabelle1!A4, i.e. 4. However, A4 is not fixed and depends on the value from cell A1 in Tabelle2

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,873

    Re: Reference to another sheet

    Excel 2016 (Windows) 32 bit
    A
    1
    =INDIRECT("Tabelle1!A4")
    Sheet: Tabelle2
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  5. #5
    Registered User
    Join Date
    06-24-2020
    Location
    Stuttgart, Germany
    MS-Off Ver
    2020
    Posts
    17

    Re: Reference to another sheet

    Thanks Alan, the indirect function was the right hint. Together with the concatenate function, I got now what I wanted to have

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,740

    Re: Reference to another sheet

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Indirect Sheet reference with cell reference left function and text
    By teststrip in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-01-2015, 10:31 AM
  2. [SOLVED] =INDIRECT, Sheet reference with Incremental cell reference
    By Deap in forum Excel General
    Replies: 4
    Last Post: 06-16-2014, 05:58 AM
  3. [SOLVED] Locked formula changes reference when rows added to reference sheet in same workbook
    By macrorookie in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-19-2014, 04:08 PM
  4. [SOLVED] Calling string inside cell reference to reference another sheet.
    By {=OR(value=array)} in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-26-2013, 04:45 PM
  5. Dragging formula, change sheet reference, but not cell reference
    By Kalilaya0419 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-13-2013, 04:50 PM
  6. [SOLVED] Nesting a sheet name reference within a cell reference???
    By Broyston in forum Excel General
    Replies: 6
    Last Post: 10-31-2005, 04:05 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