+ Reply to Thread
Results 1 to 4 of 4

Please help get INDIRECT inside INDEX to function across different worksheets

  1. #1
    Registered User
    Join Date
    06-01-2021
    Location
    EU
    MS-Off Ver
    O2019 & M365
    Posts
    2

    Question Please help get INDIRECT inside INDEX to function across different worksheets

    Hello,

    I have been spending more than 1 hour to figure this out myself but I think now I need some help. I have everything on my worksheet setup in the way I like it except for the formula in column G. Essentially, I am using an INDEX formula get the a random sample from the worksheet 'Data' returned to worksheet 'Random sample generator'. The formula I already have does this just fine, however I would like the INDEX formula to use/pick the cell range from the content of another cell, via INDIRECT but I can't get this to work.

    My current formula looks like this but I want the $A$2:$A$20230 to be picked from the cell D19 and D20
    Please Login or Register  to view this content.
    HINT: This workbook contains some VBA code however, it does not need to be used, activated or executed. It generates some random numbers and inserts them in column F. The workbook also contains some random numbers, so the formula and lookup work without the VBA.

    Thank you!
    Attached Files Attached Files
    Last edited by Silent_Broccoli_Dish; 06-06-2021 at 02:45 PM.

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    27,999

    Re: Please help get INDIRECT inside INDEX to function across different worksheets

    Try

    =INDEX(INDIRECT("'Data'!" & "A" &$D$19):INDIRECT("'Data'!" &"A" &$D$20), F4, 1)

    D19=2
    D20=20230

  3. #3
    Registered User
    Join Date
    06-01-2021
    Location
    EU
    MS-Off Ver
    O2019 & M365
    Posts
    2

    Re: Please help get INDIRECT inside INDEX to function across different worksheets

    Thank you, that worked.

  4. #4
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    27,999

    Re: Please help get INDIRECT inside INDEX to function across different worksheets

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

    Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

+ 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/ADDRESS inside LINEST function versus inside INTERCEPT
    By slny06 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-14-2019, 08:51 AM
  2. [SOLVED] Changing Cell References inside INDIRECT function.
    By Zox Tomana in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-08-2016, 12:36 AM
  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] Nesting 2 INDIRECT inside an INDEX MATCH - any ideas?
    By Sam the Monster in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-14-2013, 10:25 AM
  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

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