Results 1 to 7 of 7

Index Match To Return Transposed Array Values

Threaded View

larryg003 Index Match To Return... 05-17-2021, 09:57 AM
alansidman Re: Index Match To Return... 05-17-2021, 10:04 AM
larryg003 Re: Index Match To Return... 05-17-2021, 10:10 AM
JohnTopley Re: Index Match To Return... 05-17-2021, 10:18 AM
larryg003 Re: Index Match To Return... 05-17-2021, 02:38 PM
JohnTopley Re: Index Match To Return... 05-17-2021, 02:41 PM
Bo_Ry Re: Index Match To Return... 05-17-2021, 03:07 PM
  1. #1
    Registered User
    Join Date
    03-28-2010
    Location
    New York
    MS-Off Ver
    Office 365
    Posts
    57

    Index Match To Return Transposed Array Values

    Hi Guys,

    Hope all well. Bit of a tricky one today - I have 13 columns (A:M) where A corresponds to a unique ID and Columns B:M correspond to monthly values. ExcelForum 1.PNG

    I'm trying to create a formula that will go through each value in Column A and publish them in a column "O" and then next to them publish in order all of the values in Columns B:M. So essentially, the first value in column A will appear in 12 different rows and next to it the values in columns B:M. Then the formula will jump to the second value in column A, pull all the associated values in Columns B:M and then continue looping through this process.
    ExcelForum 2.PNG

    I know its some combination of index, match with a small but its been a while and I've forgotten how to do this. I have attached an excel which should clarify any questions.

    Thanks SO MUCH!

    Larry

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Index match array return all matching values
    By Lameimpala in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-02-2019, 12:44 PM
  2. [SOLVED] If range contains one of the values in the array, return the index of the array
    By LawCarrot in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-01-2018, 04:12 AM
  3. Replies: 2
    Last Post: 03-15-2017, 08:22 AM
  4. [SOLVED] Index / Match - match 3 input values and return the results from the index
    By t83357 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-08-2016, 07:34 PM
  5. Index and Match with Transposed Data Sources
    By HangMan in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-18-2015, 01:23 PM
  6. [SOLVED] Index/Match to Return 1D array to be used in a sumproduct
    By david0985 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-17-2014, 04:41 PM
  7. Use Index/Match Function to Return Values from an Array
    By 00pumpkin in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-11-2013, 02: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