Find Duplicates (not exact match) Two Workbooks, Two Columns

[Guitarist]

Hi Excel Forum,

I am needing assistance finding the correct formula for an issue I am running into. I have two reports of which I need to find the duplicate names using a compariosn of two columns in two workbooks. For example, I need to check and see if Aaron Taylor in workbook column A matches a name in workbook 2 column A. I have tried a few formulas such as isnumber for match, but there are a few names where the middle name is spilled out which is mismatch with that process (and is a match technically). Basically, can I place a wildcard somewhere in the formula or is there a better all around formula to use? Thank you for your help!

[JeteMc]

It may be easier for someone to help if we could see a sample.
Please utilize the instructions in the banner at the top of the page.
Let us know if you have any questions.

[Guitarist]

My apologies for not reading that part. Thank you!

=ISNUMBER(MATCH(A:A,B:B, 0))

Trying to get The last one to also show true. Thanks!

[Guitarist]

It may be easier for someone to help if we could see a sample.
Please utilize the instructions in the banner at the top of the page.
Let us know if you have any questions.

My apologies for not reading that part. Thank you!

=ISNUMBER(MATCH(A:A,B:B, 0))

Trying to get The last one to also show true. Thanks!

[JeteMc]

Try the following:

Please Login or Register  to view this content.

I advise against using whole column references.
If you convert A1:C10 into a table then that alleviates the need to adjust the formula in the event more data is added.
Let us know if you have any questions.