+ Reply to Thread
Results 1 to 3 of 3

Can Xlookup return multiple values?

  1. #1
    Registered User
    Join Date
    01-04-2023
    Location
    Germany
    MS-Off Ver
    2212
    Posts
    2

    Can Xlookup return multiple values?

    Hello,

    I hope I posted this in the right section of the forum.

    I want to make my own Journal. Currently I'm facing the problem that I need to retrieve multiple numbers from one table that have the same lookup_value.

    My current formula:
    =IF(XLOOKUP($A$1; Journal[Symbol]; Journal[Profit]); XLOOKUP($A$1;Journal[Symbol];Journal[Profit]); "None")

    As an explanation: I'm looking for for the numbers of the lookup_value. The thing is that there might be none or multiple ones.
    I got rid of the none and one entry in the table (although this seems a bit unnecessary) but is there a way for it to return all/multiple numbers?
    Maybe there's an easier formula for my problem that I don't know of or haven't used yet.

  2. #2
    Registered User
    Join Date
    01-04-2023
    Location
    Germany
    MS-Off Ver
    2212
    Posts
    2

    Re: Can Xlookup return multiple values?

    Okay, forget the line I posted above. =XLOOKUP($A$1; Journal[Symbol]; Journal[Profit]; "None") is doing just fine.

  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,508

    Re: Can Xlookup return multiple values?

    Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ 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. Using XLOOKUP to return multiple (variable) rows
    By TomPeregrinNZ in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-09-2022, 03:55 AM
  2. [SOLVED] XLOOKUP with multiple search criteria and multiple return values
    By Cuni in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 10-26-2022, 09:27 AM
  3. Help with XLOOKUP returning multiple values
    By Schuck in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-16-2022, 06:21 AM
  4. [SOLVED] Multiple XLOOKUP/INDEX(MATCH) functions to return one value.
    By AaronIsNerd in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-11-2022, 06:57 AM
  5. [SOLVED] Xlookup several columns with multiple lookup values
    By Eades1412 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 11-14-2021, 10:22 PM
  6. Xlookup return maximum value for multiple criteria
    By Excelforum2020 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-09-2021, 10:18 AM
  7. [SOLVED] XLOOKUP to return cell based on multiple criteria in single column
    By mikehay08 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-24-2021, 02:59 PM

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