I have a workbook with two sheets. Sheet1 contains a list of numbers in Column A. Sheet2 contains data in multiple columns. I need to compare the values in sheet1, Col.A to sheet2, Col.A. IF the values match, then I need to copy all the data in the corresponding row in sheet2 to sheet3. VLOOKUP won't work for this since I need to copy more than one value for each match.