| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match name not exact
Try fuzzy matching:
http://www.mrexcel.com/board2/viewto...=974873#974873 Samantha wrote: Is there a way to match a name that's not exact? I have 2 systems that are independently run, but they both have Vendor ID and Vendor Name. The problem is System1's Vendor ID is NOT the same as System2's Vendor ID. There is partial commonality on the Vendor Name, but not all. For example, the Vendor Name might be: System1: ABC Construction System2: ABC-Construction or any variation, depending on the creativity of the person entering data. Is there a function or way to match the Vendor Name and Vendor ID from both list, as close as possible in Excel, so as to limit the manual labor to this long list? Thanks in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Range? Average.. Match.. Exact? | Excel Discussion (Misc queries) | |||
| Find a not exact match using vlookup | Excel Discussion (Misc queries) | |||
| vlookup more than one exact match | Excel Worksheet Functions | |||
| Lookup returns message box when an exact match is not found | Excel Worksheet Functions | |||
| Find a match that;s not exact | Excel Worksheet Functions | |||
Hybrid Mode
