Hello. I have a worksheet in which I will have id's populated in rows and I need to vlookup another spreadsheet and retrieve records based on those ids. However, I need to retrieve all the records that appear each time for each id. For example, id XXX in the second spreadsheet has multiple rows populated, so i need to get all those rows to my worksheet 1. basically i need to vlookup multiple records for the same id. How can I do it, please? I really appreciate the help in advance.