Match the numbers from two different excel sheets

Question

Hi all. I'm trying to match Number from Book 1 and Num from Book 2. The order is different. I wanted a help to find out solution of how I can match the number and how do I know how many of them are matching and how can I separate the exceptions from them.

Book2.xlsx

Book1.xlsx

binu_acs · Accepted Answer

@nirvapatel1998 I am not sure I understand your requirment properly basedon my understanding you can use the join tool and match the records will give your the matching records and non-matching records

No matching records from the file1

Robin_McIntosh · Accepted Answer

@nirvapatel1998 - Are you wanting to join the 2 tables or just find if there is a match from book2 to book1?  Depending on your desired result, you can use Find/Replace or Join.  From the above, sounds like maybe a Join will give you the best result but not sure.

Here's a sample workflow.

nirvapatel1998 · Accepted Answer

Thank you so much for getting back quickly to me. I need the final output that shows all the matching numbers and the unmatched numbers in the same sheet.

binu_acs · Accepted Answer

@nirvapatel1998 updated the workflow