Hello, From SHEET1, compare if column "E" is EQUAL to SHEET2 column "F" AND
From SHEET1, compare if column "F" is EQUAL to SHEET2" column "I".
If its not found , write in SHEET1 column "G" : "Not found"
If its found do this :
Compare SHEET1 if column "K" is EQUAL to SHEET2 column "AB" AND
Compare SHEET1 if column "L" is EQUAL to SHEET2 column "AC"
If BOTH compared values are the same then write in SHEET1 column "H" : "OK"
THEN
Compare SHEET1 if column "AA" is EQUAL to SHEET2 column "BW" AND
Compare SHEET1 if column "AB" is EQUAL to SHEET2 column "BX"
If BOTH compared values are the same then write in SHEET1 column "I" : "OK"
NOTE THAT : Columns "F" - "I" - "E" - "F" contains the company name. All other columns contains € values.Thats the first sheet :http://i.imgur.com/wa10mtC.jpg And thats the second sheet : http://i.imgur.com/OAPe7wA.jpg
From SHEET1, compare if column "F" is EQUAL to SHEET2" column "I".
If its not found , write in SHEET1 column "G" : "Not found"
If its found do this :
Compare SHEET1 if column "K" is EQUAL to SHEET2 column "AB" AND
Compare SHEET1 if column "L" is EQUAL to SHEET2 column "AC"
If BOTH compared values are the same then write in SHEET1 column "H" : "OK"
THEN
Compare SHEET1 if column "AA" is EQUAL to SHEET2 column "BW" AND
Compare SHEET1 if column "AB" is EQUAL to SHEET2 column "BX"
If BOTH compared values are the same then write in SHEET1 column "I" : "OK"
NOTE THAT : Columns "F" - "I" - "E" - "F" contains the company name. All other columns contains € values.Thats the first sheet :http://i.imgur.com/wa10mtC.jpg And thats the second sheet : http://i.imgur.com/OAPe7wA.jpg