Hello all,
I wish to compare a list of text (Name to Match) to a static list of text (Standard Name) and pull the best match from the static list along with a matching value in percentage.
The values under the Standard Name column are static values. The values under Name to Match are string values for which I would like to find the best match from Standard name column. For instance if under column Name to Match, I have Coca-Cola Company, the code should pull The Coca-Cola Company as the best match and provide an matching level of, let's say, 95%. The accuracy levels on the table an approximation of I would like the code to do.
<tbody>
</tbody>
I have tried using a VLOOKUP with the [range_lookup] parameter set to TRUE-Approximate Match, but it does not yield the desired results. I would like to use VBA to solve this problem, would somebody please point me in the right direction?
Thank you
AC
I wish to compare a list of text (Name to Match) to a static list of text (Standard Name) and pull the best match from the static list along with a matching value in percentage.
The values under the Standard Name column are static values. The values under Name to Match are string values for which I would like to find the best match from Standard name column. For instance if under column Name to Match, I have Coca-Cola Company, the code should pull The Coca-Cola Company as the best match and provide an matching level of, let's say, 95%. The accuracy levels on the table an approximation of I would like the code to do.
Standard Name | Name to Match | Matching Standard Name | Accuracy | |
The Coca-Cola Company | Gap | The Gap Inc. | 95 | |
The Gap Inc. | Coca-Cola Company | The Coca-Cola Company | 95 | |
Bank of America | Coca-Cola Financial | The Coca-Cola Company | 75 | |
Countrywide Financial Corporation | Contrywide | Countrywide Financial Corporation | 70% | |
AOL LLC | AOL LLC | AOL LLC | 100% | |
Six Flags Inc | Tennis Supplies | No Match | ||
Northrop Gurman Corp. |
<tbody>
</tbody>
I have tried using a VLOOKUP with the [range_lookup] parameter set to TRUE-Approximate Match, but it does not yield the desired results. I would like to use VBA to solve this problem, would somebody please point me in the right direction?
Thank you
AC