Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Fuzzy matching data
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I compare data in two worksheets to find matching cells? | Excel Discussion (Misc queries) | |||
Matching data using date criteria... | Excel Worksheet Functions | |||
Only text values matching using index/match lookup - data type pro | Excel Worksheet Functions | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
Matching data in one column to another | Excel Worksheet Functions |