Results 1 to 16 of 16

Dynamic array horizontal lookup across 2D range

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-20-2011
    Location
    Oslo
    MS-Off Ver
    MS 365
    Posts
    245

    Dynamic array horizontal lookup across 2D range

    Hi,

    I have attached an example workbook where I have six separated columns with date/time values. In a seventh column, I am have a XLOOKUP formula that returns the heading of the column that contains the maximum value for that row.

    I would like to have a formula that does the same, but which doesn't require to be copied down through the column; in other words a dynamic array version.

    Does anybody know how to do that?

    Regards,
    Marbleking
    Attached Files Attached Files

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1