+ Reply to Thread
Results 1 to 4 of 4

Excel Xlookup with dynamic return range

  1. #1
    Forum Contributor
    Join Date
    08-03-2021
    Location
    London
    MS-Off Ver
    365
    Posts
    610

    Excel Xlookup with dynamic return range

    Hi,
    with xlookup is there a way to make the return array dynamic so i could I've tried nesting a match function, but this give a number which I then need convert to the range, so tried using sequence, got stuck.
    Workbook attached.

    My formula is ;

    Please Login or Register  to view this content.
    It's just a range , but I'd like the return part to change in relation to the column name,

    I've tried using index match,
    Please Login or Register  to view this content.

    Please Login or Register  to view this content.
    for the return but not got it working, any ideas,

    Richard.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,079

    Re: Excel Xlookup with dynamic return range

    How about
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    08-03-2021
    Location
    London
    MS-Off Ver
    365
    Posts
    610

    Re: Excel Xlookup with dynamic return range

    thanks, never quite sure when 0 will give me the entire range or not, any way works fine.

    So after yours I tried ;

    Please Login or Register  to view this content.

    Which also works.


    Richard.
    Last edited by Dicken; 09-18-2022 at 01:28 PM. Reason: Forget something

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,079

    Re: Excel Xlookup with dynamic return range

    Glad to help & thanks for the feedback.

+ 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] XLOOKUP Dynamic Return Value
    By MangoFresh in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-07-2022, 09:01 AM
  2. Replies: 28
    Last Post: 08-27-2022, 10:18 AM
  3. [SOLVED] XLOOKUP using INDIRECT with named range to search across multiple dynamic sheets
    By MangoFresh in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-02-2022, 11:24 AM
  4. Xlookup with dynamic return array
    By nmarcon in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-01-2022, 11:26 AM
  5. [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
  6. VBA determining blank cells and using XLOOKUP with dynamic values
    By atakatam in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-11-2021, 03:50 PM
  7. XLOOKUP with a dynamic return array
    By phrankndonna in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-04-2020, 09:33 AM

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