+ Reply to Thread
Results 1 to 5 of 5

Indirect Reference

  1. #1
    Forum Contributor
    Join Date
    01-25-2021
    Location
    Atlanta, Georgia
    MS-Off Ver
    365
    Posts
    115

    Indirect Reference

    Afternoon.

    I have a worksheet (Sheet1) which gets data from accompanying tabs using a indirect function. I select month in Sheet1 Cell A1 and data gets pulled from referenced sheets. It seems to work for Jul and Aug but I can't figure out why it doesn't work for other cells. Any ideas?
    Attached Files Attached Files
    Last edited by JyothiGrace; 05-13-2021 at 09:47 PM.

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    21,128

    Re: Indirect Reference

    What are all the choices for Sheet1 A1? Which ones don't work?
    What are all the sheet names?
    What is the formula that uses INDIRECT?
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Contributor
    Join Date
    01-25-2021
    Location
    Atlanta, Georgia
    MS-Off Ver
    365
    Posts
    115

    Re: Indirect Reference

    My file didn't attach so I just re-uploaded.......

  4. #4
    Valued Forum Contributor
    Join Date
    10-23-2012
    Location
    Adelaide, Australia
    MS-Off Ver
    Excel 2003, Office 365
    Posts
    782

    Re: Indirect Reference

    Is this what you are trying to do?

    In B2 and drag across and down =INDIRECT("'"&$A$1&"'!"&CELL("address",B2))

  5. #5
    Forum Contributor
    Join Date
    01-25-2021
    Location
    Atlanta, Georgia
    MS-Off Ver
    365
    Posts
    115

    Re: Indirect Reference

    I figured it out. The dropdown has tab names (reference) for my indirect formula but I should have used table name instead. Thanks for all replies.......

+ 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] Replace absolute cell reference with Indirect cell reference in formula
    By Roothy in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-11-2013, 04:46 AM
  4. [SOLVED] Help with Indirect reference
    By Avenger291 in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 12-12-2012, 03:53 AM
  5. [SOLVED] How to reference an entire row based on an indirect cell reference
    By echo_oscar in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-31-2012, 08:50 PM
  6. [SOLVED] indirect reference
    By Peo Sjoblom in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 06:05 AM
  7. [SOLVED] indirect reference
    By BorisS in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM

Tags for this Thread

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