Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
String search on two tables
Hello,
I have two tables where I want find the best match according to the description on both tables. The result will be the corresponding code in the second table. Example: first table code description 101 agri 102 single family 103 mobile home 104 vacant land 105 recr Second table Code Description 1000 Agricultural 1002 Single Family Residence 1003 Recreational 1004 Vacant When both tables are matched, the macro should look for the best fit in table 2 and returns the code. The 'Best fit' will depend on words that match (maybe the first 4 to 5 letters) and a count of words. The match with the highest count will define which code should be pulled.... Greatly appreciated! -- EdV -- EdV |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search string to search for wild terms in Access database | Excel Programming | |||
Wildcard search for string within a string? | Excel Programming | |||
to search for a string and affect data if it finds the string? | Excel Worksheet Functions | |||
search a string withing a string : find / search hangs | Excel Programming | |||
VBA function : How to search a string in another string? | Excel Programming |