Prev: not in array
Next: Array - retrieve certain amount of recods for query
From: LaRana6261 on 27 May 2010 17:31
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
From: Don Guillett on 27 May 2010 18:11
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
dguillett(a)gmail.com
"LaRana6261" <LaRana6261(a)discussions.microsoft.com> wrote in message
news:92FE5E68-6E5F-4FCE-99AB-4F6613F78EE6(a)microsoft.com...
> 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

 | 
Pages: 1
Prev: not in array
Next: Array - retrieve certain amount of recods for query