Find Duplicates question

[Mikelowrey]

Hello,

I have 2 docs that have phone numbers and I believe most of the numbers in doc 2, are in doc 2. So this is what I'm trying to find out.

I want to put all phone numbers from doc 1 in Column A and all numbers for doc 2 in column B and I would like excel to find duplicates. Now here is the thing, in column a there is certainly duplicates, but I want to exclude those. I just want to see if there is any number in Column B that is missing from A.

I hope I was clear enough. Thank you!

 

[Trebor76]

I just want to see if there is any number in Column B that is missing from A.

A VLOOKUP with an exact match will return #N/A for those entries in Col. B not in Col. A.

Hope that helps,

Robert

 

[Mikelowrey]

A VLOOKUP with an exact match will return #N/A for those entries in Col. B not in Col. A.

Hope that helps,

Robert

Hey Robert!

Thank you for replying, but to be honest, I am not very handy in excel, how would I find what you said? Thanks!

 

[Trebor76]

VLOOKUP is a standard Excel worksheet function just like SUM.

The following will return #N/A if there is no exact match between Col. B of the active sheet and Sheet1 of the same workbook (change to suit):

=VLOOKUP(B2,Sheet1!A:A,1,0)

 

[Mikelowrey]

VLOOKUP is a standard Excel worksheet function just like SUM.

The following will return #N/A if there is no exact match between Col. B of the active sheet and Sheet1 of the same workbook (change to suit):

=VLOOKUP(B2,Sheet1!A:A,1,0)

I have created a new sheet, where I paste it doc 1 numbers in column A and doc2 numbers in B. So i will try your option. thanks!

 

[Trebor76]

VLOOKUP works across workbooks as well - the following will lookup Col. A of sheet ConsolidatedData from workbook Book.xlsx (Book4 was open when I created the formula):

=VLOOKUP(B2,[Book4.xlsx]ConsolidatedData!$A:$A,1,FALSE)

 

[Mikelowrey]

VLOOKUP works across workbooks as well - the following will lookup Col. A of sheet ConsolidatedData from workbook Book.xlsx (Book4 was open when I created the formula):

=VLOOKUP(B2,[Book4.xlsx]ConsolidatedData!$A:$A,1,FALSE)

Where should i Paste this? sorry for my ignorance. very new to this

 

[Trebor76]

It's just a standard worksheet function so put it in whatever cell (or range of cells) you want the result to appear in.