VLOOKUP function to lookup more than 1 cell in a column
Posted by QUI on September 06, 2001 3:35 AM
I've got a problem. I have a sheet "History" which contains all the data of orders customers made in the past. Now I want that in sheet "All Orders" all the orders made by one customer are visible so I think that's possible with the VLOOKUP function but it's possible that it's looking for example for: "Customer A" and that Customer A is in cell "A1", "A3", "A8", etc. so it must look for all those cells and not only the first match but all the matches in this column. Hope someone can help me? Thank you!