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


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.


Use the FILTER function':


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