I have 2 spreadsheets.

One of them (spreadsheet A) has tens of thousands of rows with all sorts of data.

The second (spreadsheet B) is smaller, just a few thousand rows.

The data columns do not match exactly. The first spreadsheet, spreadsheet A many of the data are duplicated partially or fully, for example, a name in spreadsheet A is listed 200 times in spreadsheet B, but some of the other values are different, like address. However the address may not be an exact match bewtween spreadsheets.

I need some way to do a wildcard search to return a value (like vlookup) from a partial match between spreadsheets. But it has to be able to return multiple values/rows to each individual row in spreadsheet B. Doing this by hand would take weeks and weeks if not months, but with some sort of sieve between the two with partial matches, it would narrow down what I have to sift through and save me an incredible amount of time.

Is there anyway to do this with some special formula, or write some sort of script in visual basic?

Thanks!