Compare 2 text colomns and match rows depends by cell content
 

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