Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Trying to search for a name amongst a spreadsheet, that returns multiple orders from customers

Copper Contributor

I created a form in excel that allows me to search a name from a database on another spreadsheet. I use Vlookup and Xlookup to return some info. But neither will return rows of information that i need. If a customer has 5 orders under his name, i can only get the most recent order returned as a result. What formula do i use to return multiple rows and columns?

 

Thank you!

2 Replies

@joefling34 

Any lookup function returns only first found value. Depends on our Excel version you may use FILTER or like; or AGGREGATE with reference to row. It's better to discuss on concrete sample, how your data is structured.

@joefling34 

Use the FILTER function':

 

=FILTER(range_of_interest, name_column="specific_name", "")