How to find exact match between 2 workbooks

[Looloo]

Hi all,

Can anyone help me please:

I have two separate workbooks (saved in two different file locations), and they have hundreds of ID numbers.

I need to find exact matches of the ID numbers, but cannot seem to work the =MATCH in order to do it.

Please can someone tell me the formulas required in each worksheet for them to find the exact matches?

I was trying to use this:

=MATCH(D3,'name of other workbook',0)
when I start typing the formula in, after the D3"comma" it doesn't register when I click the other workbook

I hope that makes sense.
Any help would be greatly appreciated.

 

[bstory84]

Sounds like you just need the proper Range Address
=MATCH(D3,'Directory[Name of Workbook]WorksheetName'!Range,0)

Example of Worksheet on C drive in a the temp folder named Workbook1 referencing Sheet1 Column A.

=MATCH(D3,'C:\temp\[Worbook1.xlsx]Sheet1'!$A:$A,0)