Results 1 to 16 of 16

Dynamic array horizontal lookup across 2D range

Threaded View

  1. 11-09-2022, 03:01 PM #9
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Dynamic array horizontal lookup across 2D range

    But does it work for Row 8??

    An alternative:
    =IFERROR(INDEX($A$1:$K$1,MATCH(MAX(A2:K2),A2:K2,0)),"")
    Attached Files Attached Files
    Glenn



    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
    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] 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. [SOLVED] Sum Array Using List of criteria and a horizontal lookup
    By Greg in forum Excel General
    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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1