Thread
:
String search on two tables
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett[_2_]
external usenet poster
Posts: 1,522
String search on two tables
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"LaRana6261" wrote in message
...
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 With Quote
Don Guillett[_2_]
View Public Profile
Find all posts by Don Guillett[_2_]