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. 05-17-2021, 03:07 PM #7
    Bo_Ry is offline
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,222

    Re: Index Match To Return Transposed Array Values

    Please try dynamic array

    =CHOOSE({1,2},INDEX(A2:A5,SEQUENCE(COUNTA(B2:M5&1),,,1/COLUMNS(B2:M5))),FILTERXML("<x><m>"&TEXTJOIN("</m><m>",0,B2:M5)&"</m></x>","//m"))
    Attached Files Attached Files
    Linkedin/Bo-Rydobon
    Youtube.com/XcWizard
    Facebook.com/XcWizard
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

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. Index Match - Return unique results when Lookup Array contains duplicate values
    By STUARTXL in forum Excel Formulas & Functions
    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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1