Hello,
I have a dificult problem, i have 2 lists of products name, one of them
is the original list from my database and the other one is a supplier
list.
I put my list in colomn A and supplier list in colomn B.
I want hel for a macro to comare every rows from my list with every
rows from supplier list and match rows by must aproiate content in
other colomn/colomns if are more that one match. If for a row from my
list is not match, the results will be: "not match"
Example
colomn A:
TINCTURA AFIN 50ml HOFIGAL
TINCTURA ALOE 50ml HOFIGAL
TINCTURA ARDEI IUTE 50ml HOFIGAL
TINCTURA ARMURARIU 50ml HOFIGAL
TINCTURA ARNICA 50ml HOFIGAL
TINCTURA BRUSTURE 50ml HOFIGAL
colomn B:
Tinctura Aloe
Tinctura Trei Frati Patati
Ulei Catina
Ulei Lavanda
Ulei Masaj
Tinctura Busuioc
Tinctura Brusture
Tinctura Arnica
colomn C:
NOT MATCH
Tinctura Aloe
NOT MATCH
NOT MATCH
Tinctura Arnica
Tinctura Brusture
Thanks,
Marian
--
PRONET
------------------------------------------------------------------------
PRONET's Profile:
http://www.excelforum.com/member.php...o&userid=36885
View this thread:
http://www.excelforum.com/showthread...hreadid=566691