A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Check out the FILTER function
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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!
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
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.
Check out the FILTER function