Hi,
I'm super new to this but I am trying to match two different address columns from two different spreadsheets that will spit out the match and the percentage.
I have a primary address spreadsheet that contains over 60,000 addresses but also contains the floor, unit, and suite number at the end of the address:
Primary address table:
| ID_Table | Address |
| 1 | 123 Milner Ave Floor 1 |
| 2 | 321 Argyle St Unit 2 |
| 3 | 322 Elgin St Floor 3 |
| 4 | 323 Elizabeth St Unit 3 |
| 5 | 324 King St Floor 32 |
| 6 | 325 Queen St Floor 4 |
I want to be able to match against my secondary table that contains approximately 2000 addresses. However, addresses in this table are messier and can contain the full address including postal code, city, punctuations, typos, etc.
Secondary Address Table:
| ID | Address |
| 1 | 1000 Airport Rd, Ottawa, ON K1T 3E2 |
| 2 | Bronte Park, 1293 Burloak Drive (Park Office) |
| 3 | 74 Wilson Rd |
| 4 | 5 Steve Street |
| 5 | 83 Lorne St. |
| 6 | 3423 Bay Road. N (left) |
I'm expecting this sort of output:
| ID_Table 1 | Address_Table 1 | ID_Table 2 | Address_Table 2 | Percentage Match |
| 1 | 123 Milner Ave Floor 1 | No Match | No Match | % |
| 2 | 321 Argyle St Unit 2 | 4 | Ottawa, 321 Argyle St, K2L 3B2 | % |
| 3 | 322 Elgin St Floor 3 | 5 | 322 Elgin St. | % |
| 4 | 323 Elizabeth St Unit 3 | 2 | Bronte Park, 323 Elizabeth St (Park Office) | % |
| 5 | 324 King St Floor 32 | No Match | No Match | % |
| 6 | 325 Queen St Floor 4 | 6 | 325 Queen St. N (left) | % |
| No Match | No Match | 1 | 1000 Airport Rd, Ottawa, ON K1T 3E2 | % |
| No Match | No Match | 3 | 74 Wilson Rd | % |
When I use the fuzzy match tool it doesn't seem to give me the results that I expect? Any ideas?
Thanks!
