Comparing two sheets

I can't go on with the comparing of two sheets in two different workbooks in Excel. What im trying to code is :

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 "I" is EQUAL to SHEET2 column "AB" AND

Compare SHEET1 if column "J" 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 "Y" is EQUAL to SHEET2 column "BW" AND

Compare SHEET1 if column "Z" 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.

EDIT #1 :

The compare is Row by Row . Each Row of SHEET1 to SHEET2 rows ( there are for SURE more rows in SHEET2 ) , The length of columns is the same as how many rows are in the sheet.

Thanks .

It looks like you need an IF/ISNA string. I'm not entirely sure how the string would look but I believe it would start out with something similar to..

Formula:

Please Login or Register  to view this content.

Hopefully that puts you on the right path for researching a solution.

Kind Regards,

Tommy Bailey

I've write that code:

Please Login or Register  to view this content.

But its comparing wrong the columns since its not sure that e.g. SHEET1 column X1 is the located in SHEET2 column X1