Forum Discussion
joefling34
Sep 02, 2023Copper Contributor
Trying to search for a name amongst a spreadsheet, that returns multiple orders from customers
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!
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.