FORMULA HELP COMPARING TWO COLUMNS OF DATA THAT ARE NOT AN EXACT MATCH

Hello,

If anyone could help me with this, I would greatly appreciate it. I am looking for a formula that will help me with the following situation.

 I have two columns in a very large data set. Column A and Column B. Column A contains street addresses that may or may not be within Column B. Column A has significantly fewer rows than Column B. The addresses in Column A are also not complete addresses as they are all missing the acronym at the end (ST, CT, RD, ect) and some are missing the cardinal direction (N, S, ect.). The address in Column B are complete addresses with all of the necessary information. How do I write a formula that looks for and identifies matches between columns for every record in Column A?

 

Sample

 

 

column A column B

 
 

 

 
 

 

637 W WELCH

585 W WELCH ST

4440 N KILEE

595 W WELCH ST

4537 N KILEE

637 W WELCH ST

2464 MEADOWGLEN

638 W WELCH ST

2547 N MEADOWGLEN

4432 N KILEE AVE

2788 FAIRGLEN

4440 N KILEE AVE

2860 FAIRGLEN

4441 N KILEE AVE

2873 N FAIRGLEN

4471 N KILEE AVE

 

2464 N MEADOWGLEN PL

 

2467 N MEADOWGLEN PL

 

2489 N MEADOWGLEN PL

 

2498 N MEADOWGLEN PL

 

2525 N MEADOWGLEN PL

 

2530 N MEADOWGLEN PL

 

2542 N MEADOWGLEN PL

 

2547 N MEADOWGLEN PL

 

2762 N FAIRGLEN AVE

 

2788 N FAIRGLEN AVE

 

2789 N FAIRGLEN AVE

 

2821 N FAIRGLEN AVE

 

2822 N FAIRGLEN AVE

 

2839 N FAIRGLEN AVE

 

2857 N FAIRGLEN AVE

 

2860 N FAIRGLEN AVE

 

2873 N FAIRGLEN AVE

 

1002 W CHATEAU AVE

 

1002 W DELMAR DR

 

1002 W LOWRY ST

 

1003 W CHATEAU AVE

 

1003 W GREAT BASIN DR

 

1004 E CHATEAU DR

 

1004 E CLAYBOURNE DR

 

1004 N SCRIVNER WAY

 

1004 W GREAT BASIN DR

 

1004 W STOREY AVE

 

1005 E CHATEAU DR

 

1005 E CLAYBOURNE DR

 

1005 E WASHAKIE ST

 

 

 

 

By: Ethan Morton

Leave a Reply

Your email address will not be published. Required fields are marked *