Index/ Lookup formulas and fuzzy matching
 

Hi

I have two spreadsheets of similar property data, and Im trying to create a
formula in spreadsheet A that will look in spreadsheet B, find the matching
property data then return corresponding data to spreadsheet A.
Im using the Index formula for this and name ranges, and everything works
fine if the property data in spreadsheet A exactly matches spreadsheet B. If
there is a slight difference it falls down e.g. spreadsheet A property named
'28 St Marks House', spreadsheet B property named 'Flat 28 St Marks House'.
Does anyone know of a matching/lookup/index method that could get around this?
The formula Im currently using is -
=INDEX(CompareV2.xls!gaz,MATCH(M3519,CompareV2.xls !flat,0),1)
'gaz' and 'flat' being name ranges.

Hopefully this makes sense!

Cheers