• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 60
  • Last Modified:

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?
0
dcmathis
Asked:
dcmathis
1 Solution
 
als315Commented:
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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now