+ Reply to Thread
Results 1 to 2 of 2

[Solved] Start offset reference in array based on specified value

  1. #1
    Registered User
    Join Date
    07-28-2019
    Location
    Atlanta, United States
    MS-Off Ver
    Excel 2016
    Posts
    15

    [Solved] Start offset reference in array based on specified value

    Example is attached. I'm trying to dynamically pull the value of the cell either directly one or two cells to the right of a cell in an array. And the starting point in that array is based on a specified value. Below is a picture.

    Capture.PNG
    Attached Files Attached Files
    Last edited by Barren_Wuffett; 09-09-2019 at 11:28 PM. Reason: [Solved]

  2. #2
    Registered User
    Join Date
    07-28-2019
    Location
    Atlanta, United States
    MS-Off Ver
    Excel 2016
    Posts
    15

    Re: [Solved] Start offset reference in array based on specified value

    =OFFSET(INDEX(G2:P2,1,MATCH(R2,G2:P2,0)),0,1)

    Figured it out.

+ 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. Offset based on cell reference
    By scottjn in forum Excel General
    Replies: 10
    Last Post: 01-02-2020, 09:02 AM
  2. [SOLVED] unable to use offset or indirect in array with non-numerical cell reference
    By NooobV in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 06-04-2018, 06:09 AM
  3. [SOLVED] Use cell location of SMALL array formula as OFFSET reference?
    By mattmars in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-23-2016, 07:30 PM
  4. [SOLVED] Array Formula to find an offset value based on a certain condition.
    By montehoskey in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-14-2014, 10:54 PM
  5. [SOLVED] Combining subtotal sum with offset using an array for row reference
    By John Vieren in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-31-2013, 05:47 AM
  6. [SOLVED] VBA array based on =cell reference
    By Needhelp!!! in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 08-01-2013, 05:49 PM
  7. Replies: 2
    Last Post: 02-17-2011, 04:00 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