hi guys

I am looking for a macro or formula for this please: Basically, as you can see above I have 2 sheets, I need a marco that will place the result in E1,2,3 etc on Sheet 2. The marco/formula needs to look at Sheet1 Columns C and D, find exact match in the same columns on sheet 2, then give a value in sheet 2 cell E.


Sheet 1

C1 - Scots
C2 - Scots

D1 - EH13
D2 -EH12


Sheet 2

C1 - Scots
C2 - Scots

D1 - EH13 (gives a 0 in E1 sheet 2 as its found a match)
D2 - EH1 (gives a 1 in E2 sheet 2 as its has not found a match)



as ever thank you guys in advance for any help you can help