Tried Fuzzy Tool but didn't work

[ctackett6407]

Greetings,

Right now I have two sources that I can export an excel file. There is not a common key between the two so I can accurately tie the data together, but I have at least 10k lines of data to compare in one excel and about 30k lines of data in the other file.

I do have one small shard of hope when I noticed there is a Service Address Column that contains addresses and something similiar in the other excel file; however, I noticed that Service Address Column in the largest file contains addresses that match the other excel but... there is some additional wording in the name .. see examples below.

SERVADD
1234 Main Trl
54634 State Road 123 Hanger
92929 Nothing Ln House

and in the other excel file it shows

1234 Main Trl
54634 State Road 123
92929 Nothing Ln


my dream.. my goal..

Is to compare the two excel files and

I want to compare masterfile1234 and exportfile1234

I want to match the SERVADDR1 filed from masterfile1234 to the Street Address field of exportfile1234

If they match, I want it to grab certain column data from the masterfile1234 and it into the exportfile1234 line.

PostNumber | StarsNo | Account# | CarTag | ServAddr1

So the above would be masterfile1234

if ServAddr1 matched the Street Address of ExportFile1234 then a new sheet would be created and capture the the entire line of exportfile1234 and then add the PostNumber data, Account # data, and the CarTag data..

There is already an existing Account Number filed on the exportfile1234, but I don't know how to make things populate in that column.

I tried Ablebits and Fuzzy Tools but I couldn't get anything to work for me so I figured it's not possible, but I found a google about Addresses and Searches.. which led me to Fuzzy tools but that kept me busy for 9 hours and accomplished nothing.

 

[mole999]

something like LEFT(cell,12) might help to get it to match OR maybe use the short value with a wildcard maybe, it won't necessarily be 100%. the other option would be to suppress / remove the last key identifier house / hanger in the reference file by adding a column