Comparing Address and produce out of exact address

[pramoth.u]

Hello Experts,

I need a formula help with regard to the address comparison.

Am attaching the before and after sample sheet where i need to search a few related parameters in the address(ie Address 1 Columns ) in "Comparing Address2" and produce/need the matching address details ie Address 1.

Your timely assistance will be highly appreciated.

Regards
Pramoth.U

[JohnTopley]

What is to be compared and how is the "required" address determined?

All your examples have "Address 1" as "After" : why?

[pramoth.u]

Hello JohnTopley
My requirement is to search a related word in both columns ie "Address 1" and "Comparing Address2" and give the output as in Address 1 column.

For Eg in first line item of both "Address 1" and "Comparing Address2" columns "MAKER TOWER" is the genertic word if those key word matches needs an ouput as a address in column Address 1.

[JohnTopley]

How do we know what these "generic" words are?

[pramoth.u]

just a comparison/search check on the address given in both columns and produce the output on the matching cases.

[pramoth.u]

Hi All,

I have got the expected ouput using left/match/index formulas.Thanks

Attaching the formula reference output file for your reference(Refer solved formula column).