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.
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.