+ Reply to Thread
Results 1 to 16 of 16

Dynamic array horizontal lookup across 2D range

Hybrid View

Marbleking Dynamic array horizontal... 11-08-2022, 12:27 PM
Limor_OP Re: Dynamic array horizontal... 11-08-2022, 02:20 PM
Marbleking Re: Dynamic array horizontal... 11-09-2022, 03:09 AM
AliGW Re: Dynamic array horizontal... 11-09-2022, 03:12 AM
HansDouwe Re: Dynamic array horizontal... 11-09-2022, 05:20 AM
Limor_OP Re: Dynamic array horizontal... 11-09-2022, 01:00 PM
HansDouwe Re: Dynamic array horizontal... 11-09-2022, 02:04 PM
Limor_OP Re: Dynamic array horizontal... 11-09-2022, 02:31 PM
Glenn Kennedy Re: Dynamic array horizontal... 11-09-2022, 03:01 PM
Limor_OP Re: Dynamic array horizontal... 11-09-2022, 03:04 PM
Glenn Kennedy Re: Dynamic array horizontal... 11-09-2022, 03:11 PM
Limor_OP Re: Dynamic array horizontal... 11-09-2022, 03:21 PM
Limor_OP Re: Dynamic array horizontal... 11-09-2022, 03:16 PM
HansDouwe Re: Dynamic array horizontal... 11-09-2022, 04:16 PM
Marbleking Re: Dynamic array horizontal... 11-10-2022, 03:35 AM
Glenn Kennedy Re: Dynamic array horizontal... 11-10-2022, 04:27 AM
  1. #1
    Forum Guru HansDouwe's Avatar
    Join Date
    06-21-2022
    Location
    Nederland
    MS-Off Ver
    365 V2403 (Build 17330.20000)
    Posts
    6,466

    Re: Dynamic array horizontal lookup across 2D range

    Or try
    Formula: copy to clipboard
    =BYROW(A2:K12,LAMBDA(r,INDEX(SORTBY(A1:K1,r,-1),1)))
    BYROW and LAMBDA should be available to all EXCEL 365 users
    Attached Files Attached Files

+ 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. [SOLVED] COUNT Dynamic Array based on Date to return Dynamic Array Spill Range
    By dluhut in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-06-2022, 01:14 PM
  2. [SOLVED] Lookup that returns vertical array in horizontal format
    By chanelinyavapai in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-25-2022, 10:50 AM
  3. [SOLVED] Horizontal dynamic range not working
    By steam73 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-01-2017, 09:32 AM
  4. [SOLVED] Finding the (Dynamic) End of a Horizontal Range
    By Lemmy Kickit in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-12-2016, 06:52 PM
  5. [SOLVED] lookup if my lookup array with my data position is vertical and horizontal
    By daboho in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-29-2015, 05:35 AM
  6. Dynamic Chart Range for Horizontal values
    By phill_howz in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-03-2014, 11:47 AM
  7. Replies: 7
    Last Post: 05-21-2005, 07:06 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