Data Matching and/or Fuzzy Lookup

[arbitrage1]

Hello everyone,

I had a question i was hoping someone could help me with. I have two large data sets in Excel. A-E and G-K. I need to see if the data in Columns B,C,D and E match the data in columns H,I,J and K. If so I would like a new sheet or workbook to hold the matches and those that do not match to be put at the bottom of the table. I have tried with Fuzzy Lookup and it worked but the data that did not have a match was deleted. Does anyone know why it was deleted or a way to keep that data after fuzzylookup has done its job? Any help would be greatly appreciated.

Before
[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[TD]K[/TD]
[/TR]
[TR]
[TD]Code[/TD]
[TD]Unit[/TD]
[TD]Res[/TD]
[TD]Date[/TD]
[TD]Amount[/TD]
[TD][/TD]
[TD]Code[/TD]
[TD]Unit[/TD]
[TD]Res[/TD]
[TD]Date[/TD]
[TD]Amount[/TD]
[/TR]
[TR]
[TD]A1[/TD]
[TD]1[/TD]
[TD]ABC[/TD]
[TD]1/27/17[/TD]
[TD]100[/TD]
[TD][/TD]
[TD]A1[/TD]
[TD]1[/TD]
[TD]ABC[/TD]
[TD]1/27/17[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]B1[/TD]
[TD]1[/TD]
[TD]BCD[/TD]
[TD]1/1/17[/TD]
[TD]50[/TD]
[TD][/TD]
[TD]B1[/TD]
[TD]2[/TD]
[TD]ZZZ[/TD]
[TD]1/5/17[/TD]
[TD]35[/TD]
[/TR]
[TR]
[TD]A1[/TD]
[TD]2[/TD]
[TD]XXX[/TD]
[TD]1/5/17[/TD]
[TD]27[/TD]
[TD][/TD]
[TD]B1[/TD]
[TD]1[/TD]
[TD]BCD[/TD]
[TD]1/1/17[/TD]
[TD]50[/TD]
[/TR]
</tbody>[/TABLE]

After
[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[TD]K[/TD]
[/TR]
[TR]
[TD]Code[/TD]
[TD]Unit[/TD]
[TD]Res[/TD]
[TD]Date[/TD]
[TD]Amount[/TD]
[TD][/TD]
[TD]Code[/TD]
[TD]Unit[/TD]
[TD]Res[/TD]
[TD]Date[/TD]
[TD]Amount[/TD]
[/TR]
[TR]
[TD]A1[/TD]
[TD]1[/TD]
[TD]ABC[/TD]
[TD]1/27/17[/TD]
[TD]100[/TD]
[TD][/TD]
[TD]A1[/TD]
[TD]1[/TD]
[TD]ABC[/TD]
[TD]1/27/17[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]B1[/TD]
[TD]1[/TD]
[TD]BCD[/TD]
[TD]1/1/17[/TD]
[TD]50[/TD]
[TD][/TD]
[TD]B1[/TD]
[TD]1[/TD]
[TD]BCD[/TD]
[TD]1/1/17[/TD]
[TD]50[/TD]
[/TR]
[TR]
[TD]A1[/TD]
[TD]2[/TD]
[TD]XXX[/TD]
[TD]1/5/17[/TD]
[TD]27[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]B1[/TD]
[TD]1[/TD]
[TD]BCD[/TD]
[TD]1/1/17[/TD]
[TD]35[/TD]
[/TR]
</tbody>[/TABLE]

Any ideas?
Thanks,

 

[cchavez24]

Here is how I have done it in the past.

Paste both data sets onto an seperate sheet below each other. Use the Autofilter to delete all duplicate records based on all the columns A-E. And you will have your desired outcome.

Let me know if you have any questions.