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 |
All times are GMT +1. The time now is 01:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com