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