if statement

[censura]

Hi i wonder if anyone can help

I have a worksheet which compares results in columns b-z with results in column A.

I wish to have the result be either 1 a match -1 do not match 0 when no result is produced in columns b-z.

Column A the cells have either 1 or -1 , the Cells in columns b-z have either 1,-1 or 0

Eg

Column

A,B,C,D

-1,1,0,-1

so the results would be compare in B2 with A2 = -1 (no match)
C2 with A2 = 0 as no result was generated in C2,
D2 with A2 =1 a match.

To clarify the match is with column A so B2 with A2, C2 with A2, D2 with A2 etc

hope you can help
thanks

[BigBas]

This is doable, but where do you want to put the "match", "do not match" result?

[censura]

Hi thank you for your help the match and not matches will go in another worksheet ie match B2 A2 in sheet1 will be in b2 in sheet2 C2 A2 match will appear in sheet 2 in C2

hope this helps