Match the numbers from two different excel sheets

[nirvapatel1998]

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. 

[binuacs · Accepted solution]

@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 solution]

@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 solution]

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. 

[binuacs · Accepted solution]

@nirvapatel1998 updated the workflow