Cancel

[mickgibbons1]

hi guys

hi guys

i am looking for a marco 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 across 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