Match cells with cells on another workbook
 

I have 2 workbooks: 15,000 names, addresses and refernece numbers. On another
I have 100 names addresses and ref numbers. How do I find out if the 100 are
on the workbook with 15,000? I need to use the refence numbers.

Match cells with cells on another workbook
 

On the small file, add a new column next to the ref numbers.

Col A Col B
Ref# New
AS15 =vlookup(A1,Bigfile!A:A,1,0)
AS20 =vlookup(A2,Bigfile!A:A,1,0)
AS35 etc

You just need to make sure you are looking in the right column in the big
file. I put column A above but you can change that.

Every reference that is found will be repeated.
Anything not found will give you a #N/A error.

you can then sort these or autofilter them to isolate them.
--
Allllen

--
Allllen


"James1976" wrote:

I have 2 workbooks: 15,000 names, addresses and refernece numbers. On another
I have 100 names addresses and ref numbers. How do I find out if the 100 are
on the workbook with 15,000? I need to use the refence numbers.