Macro to compare against multiple criteria two sheets

Hi Guys,


I would need a macro that can check if for a given code in Column A all the criteria/values (columns B:C:D etc.) are the same for the same code in another sheet of the workbook.
Could anyone help me please?




1.The same code can be repeated several times with different values.
2.The numbers of row of the two sheets can be different.
3.Some value-cells can be empty.
4.Criteria could be more then 3. (lets say 4-5)
5.I would like a column in the sheet-1 that gives back a "V" only if ALL the criteria for the given code match in the two sheets.
6.I tried the below formula with Index/Match in Array (Match with a boolean) but it doesn't work:

=INDEX(Sheet2!$A$2:$E$12,MATCH(1,(Sheet1!A2=Sheet2!$A$2:$A$12)*(Sheet1!B2=Sheet2!$B$2:$B$12)*(Sheet1!C2=Sheet2!$C$2:$C$12)*(Sheet1!D2=Sheet2!$D$2:$D$12),0),5)

Thanks everybody in advance.