Compare values between two columns and copy matching data to new sheet.

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.


Book3.xlsx

Any suggestions?
dcmathisAsked:
Who is Participating?
 
als315Connect With a Mentor Commented:
Try this sample (press button on Sheet1)
Book3.xlsm
0
 
dcmathisAuthor Commented:
Thanks!  That should work just fine.  Amazing what a second opinion will do for you.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.