Match Similar Strings in Different Columns/Tables

[moscott75]

I have two tables. Table 1has Electric Company addresses and table 2 home addresses. I am trying to link the power company meters to the correct home addresses but the home address are some what different. How can I link the meters like the diagram below? Is there a formula I can use that will return true if more that 3 to 4 words or number match?

Electric Company:::METER#::::: Home Address:::::::METER#
123 ABC ST:::::::::888:::::::::: C 100 KM40 HM9:::::999
666 HIGHWAY 5 :::777::::: ::::: ABC ST 123:::::::::::888
CARR 100 K40::::: 999:::::::::: HWY 5 # 666:::::::::777

 

[Aladin Akyurek]

Let's assume that the electric table is in A:B, the home table in E:F.

In C2 enter and copy down:

=IFERROR(INDEX(E:E,MATCH(B2,F:F,0)),"not found")

 

[moscott75]

Thanks for you feedback. My outcome isn't there yet

Address Meter??
123 ABC
555 ccc
888 F Hwy
KM32 10 HM5

Electric Company Meter
123 abc 999
10 K32 H5 555
888 Farm Rd Highway 777
555 ccc#6 888

This is want I want. I wanted to be able to be able to associate the Electric Company Meter numbers with the Home addresses although the addresses are some what different. I have two tables with 1000 rows.
Address
123 ABC 999
555 ccc 888
888 F Hwy 777
KM32 10 HM5 555

 

[Aladin Akyurek]

Care to post the samples above using one of the possible methods listed in https://www.mrexcel.com/forum/about-board/508133-attachments.html#post2507729

 

[moscott75]

I am trying to link address that are not exact but close in match. I want to associate the Electric Company meter number to house address but the addresses don't have the same text values but is the same property. How can link the Electric Company meter# to the home address where the address are not exact but are the same property.

Book1
	A	B	C	D	E
1	Electric Company	Meter		House Address
2	123 ABC ST	9996		ABC ST #123
3	888 RUSHMORE RD	9977		Carr KM 32 HM7.2
4	123 K32 H7	9912		St Concordia # 56
5	5 Ruiz Rivera	9958		Calle Ruiz Rivera #5
6	56 Concordia St	9942		RD 888 Rushmore
7
8	This is the Outcome I want
9	Home Address	Meter# Added
10	ABC ST #123	9996
11	RD 888 Rushmore	9977
12	Carr KM 32 HM7.2	9912
13	Calle Ruiz Rivera #5	9958
14	St Concordia # 56	9942
Sheet1

 

[Aladin Akyurek]

Thanks for the sample. Try to use fuzzy matching described in: https://www.mrexcel.com/forum/excel...lus-explanation.html?highlight=fuzzy+matching