Results 1 to 7 of 7

Changing Cell References inside INDIRECT function.

Threaded View

  1. #1
    Registered User
    Join Date
    06-07-2016
    Location
    Fort Worth, Tx
    MS-Off Ver
    Office 365 ProPlus
    Posts
    4

    Changing Cell References inside INDIRECT function.

    Howdy. So I'm fairly inexperienced with Excel, but have gotten myself into a project where something I want to do seems to have turned out to be something of a chore. I have multiple sheets, and I want to have a single summary sheet that pulls data from one of the other sheets based upon the contents of a specified cell on the summary sheet. Thanks to Google and some posts on this very site, I've figure out how to do that:
    =INDIRECT($A$1&"!A1")
    where the second "A1" is just an example. Now here comes the problem that brought me here: I need to 1. be able to drag-autofill the formula across many cells such that the second A1 is changing to refer to new, specified cells on the other sheet, and 2. have the cell references increment by more than 1 when filling down the column (specifically I need it to increment by 4).

    This summary sheet it going to be pulling whether or not a radio has been signed out, and who has had that radio, during a particular day. It is the "who" part that involves the trouble, because each "who" is four rows down from the last. From my table:

    C3: Who:
    C4: Out:
    C5: In:
    C6: [BLANK ROW]
    C7: Who:
    C8: Out:
    C9: In:

    Therefore the cells (say) B2, B3, B4 need to pull from C3, C7, and C10.

    So, any clues on how to get the second A1 to increment, and how to get it to increment by 4?
    Last edited by Zox Tomana; 06-07-2016 at 08:29 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] INDIRECT Function NOT capturing all of the references
    By Murphy15 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 02-09-2017, 10:00 PM
  2. Using Structured Table References and Indirect Function
    By tjeasy in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-02-2016, 07:07 PM
  3. Using Indirect function inside the Search function
    By skhari in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-20-2014, 05:32 PM
  4. INDIRECT function not working inside MATCH with dynamic ranges
    By fotografer in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-26-2014, 02:09 AM
  5. INDIRECT inside a LINEST function
    By Glenn Kennedy in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-24-2013, 12:06 PM
  6. [SOLVED] Changing cell references in INDIRECT function
    By GavJ in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-25-2013, 11:38 PM
  7. [SOLVED] Using ROW function inside of both an Indirect and Index function returns #VALUE
    By xandermacleod in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-11-2012, 06:22 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