<div>
Why are they on different shees? <br />
<br />
Open both files, create named ranges, and do a vlookup.<br />
would you like an example of what that formula would look like?
</div>


Why are they on different shees?

Open both files, create named ranges, and do a vlookup.
would you like an example of what that formula would look like?

<div>
Open both files and Perform a MATCH (VLOOKUP would be slow and overkill)<br />
<br />
So in book 1 (row 1 in this case) you would have a formula... <br />
<b>=MATCH(A1,</b><i>OrderNumbers Book 2 Sheet A:A</i><b>, 0)</b><br />
The 0 is nescessary to show exact matches only.<br />
Then any rows which are #N/A are missing from the second workbook.<br />
Reverse the procedure to find those in second workbook missing from first.
</div>


Open both files and Perform a MATCH (VLOOKUP would be slow and overkill)

So in book 1 (row 1 in this case) you would have a formula...
=MATCH(A1,OrderNumbers Book 2 Sheet A:A, 0)
The 0 is nescessary to show exact matches only.
Then any rows which are #N/A are missing from the second workbook.
Reverse the procedure to find those in second workbook missing from first.

<div>
Dear Barman<br />
<br />
Thanks, it's perfect,<br />
<br />
But if I would like to show that the matched number as &quot;Y&quot; and the unmatched as &quot;N&quot;, how should I modify the formula?<br />
<br />
<br />
Desmond
</div>


Dear Barman

Thanks, it's perfect,

But if I would like to show that the matched number as "Y" and the unmatched as "N", how should I modify the formula?


Desmond

<div>
Dear Andy,<br />
<br />
There are two different files is because if come from different report and we would like to compare the result.<br />
<br />
regards,<br />
<br />
Desmond
</div>


Dear Andy,

There are two different files is because if come from different report and we would like to compare the result.

regards,

Desmond

<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
I've two excel files (File A and File B) that have order no.(both on colum A) which are similar but not exact.<br />
<br />
Now, I would like to know what order number listed on File A is missing from File B and vice versa.<br />
<br />
thanks for your help in advance.<br />
<br />
<br />
Desmond
</div>
</div>


Hi Experts,

I've two excel files (File A and File B) that have order no.(both on colum A) which are similar but not exact.

Now, I would like to know what order number listed on File A is missing from File B and vice versa.

thanks for your help in advance.


Desmond

Matching the number in two excel file

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.