Very confusing issue- HELP

So, I am trying to figure out a way to solve a work issue so I have attached a sample document that I'm hoping will make my situation easier.

Sheet 1 contains information for dog breed, size, and dog ID. The Dog ID is the unique identifier, the dog breed and size will always match. The dog location can vary and is not particular to any column

Sheet 2 contains essentially the same data, but less.

for the "New Data" sheet, I want the Dog ID in sheet 2 to find the its Dog ID duplicate in sheet 1 and paste all of the new data (that aren't duplicates) in the "new data" sheet. I want the entire row to be pasted, not just the id. Does this make sense and can someone please please help me? Thank you!!

PS I have tried VLOOKUP But i cannot figure out how to return multiple rows of information.

In each sheet I have put DOG iD in column A

in "New DatA"

in A2

=IF(Sheet2!A2<>"",Sheet2!A2,"")

in B2

=IFERROR(VLOOKUP($A2,Sheet1!$A$2:$E$17,COLUMNS($A:B),0),"")

Copy across to E and down

Thank you very much!! That worked!!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

In future, make sure your thread title is more meaningful e.g. How to/ formula to copy data from one sheet to another

Actually wait, I wanted to return the values in "New data" that were not duplicates. For instance, I wanted to return 357, 641, 841 (the ones that weren't in sheet 2) Sorry If i didn't specify this clearly enough.

Perhaps your sample is not too realistic as all DoG IDs on Sheet2 appear on Sheet1 so "New Data" + Sheet1 ????

A quick way do this is to Put Sheet1 data into "New Data" then add the "Sheet2" data and use the toolbar: "Data"==> "Remove Duplicates"