Forum Discussion

joefling34's avatar
joefling34
Copper Contributor
Sep 02, 2023

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!

  • 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.

Resources