Formula vs Vlookup

[buteaur]

Hello everyone.

I have a need to compare two columns of data (A1-A100 to E1-E100) however, the text in the columns is not always an exact match.

Example

A1= Atlanta GA 1a1
E4= GA Atlanta 1a1

I need to see if I can have Excel figure out that these are the same thing by being "close enough" and then return a value that's assigned to that data (Atlanta GA 111) from column G1-G100.

Is this possible?

 

[RedWolf3x]

Will they always have the same words? Or would the following also match?


A1 = Atlanta GA 1a1
E1 = GA Atlanta 1a 1
or
E1 = GA Atlanta

 

[buteaur]

your example would also be a possibility.