There's a number of possibilities,
1. a key column on your data page that is set to your search and then an INDEX/MATCH function to pull data
2. an arrayed function using INDEX/MATCH/SMALL to pull only the appropriate values
3. A double INDEX'ed Function to remove the necessity to use an ARRAY
It would require a sample workbook from you (go advanced>Manage Attachments)
Bookmarks