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
Bookmarks