Comparing Two Columns with partial matches

**cartoking** · 05-16-2013, 04:20 PM

Does anyone know a way in excel to compare two columns A and B and return a 1 or a 0 if their is a partial match?
The data consists of addresses and street names I am trying to manually weed through these but thought the process might be automating in Excel with proper code.

Example.

Column A
Corvey Ln

Column B
10531 Corvey Lane

Can simple code derive a match from just comparing 3-4 characters in each column "Corv" and call it 1
Keep in mind many of the addresses are not standardized and I am wanting the compare to just key in on 3-4 characters and call it 1 and if those don't match it = 0.

**Harribone** · 05-16-2013, 04:48 PM

Maybe you can use the below in col c (C2):

=IF(ISNUMBER(FIND(LEFT(A2,3),B2)),1,0)

This will work if you want to compare the first 3 letters from A to see if exists anywhere in B.