Share via

How to find multiple matches to a single input. XLOOKUP only returns first value.

Anonymous
2023-03-22T20:19:24+00:00

Hi, this question may have a fairly simple answer, but I haven't managed to figure this out using XLOOKUP() - or another function. How do I tell it to keep searching and return the values in a column for all instances of an input value in another column, rather than stopping the first time it encounters a match? I saw a solution using Index, Small and Row functions, but only for one input and one column output. I have multiple input values to search, and want to return multiple columns. Many thanks in advance for any assistance anyone could offer!

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

1 answer

Sort by: Most helpful
  1. HansV 462.6K Reputation points MVP Volunteer Moderator
    2023-03-22T21:22:16+00:00

    Check out the FILTER function

    6 people found this answer helpful.
    0 comments No comments