address data comparison between sheets with non exact data

[RougeFaction]

I am currently trying to match address from customer inputs to supplier provided data, however as shown in images the formatting doesn't match up. What we would want to do is compare the address in the Add Reads sheet to the Email Data, bring back a match and display address details in Add reads sheet F column, so that a visual confirmation can be returned. Grateful for any pointers or steers as currently unable to find solution.

 

[Alex Blakenburg]

Unless I am mistaken the 2 images are identical.
So without having seen your data, have a look to see if fuzzy matching will work for you - refer my post here.
Correct text list fix or lookup against correct list