Cancel

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

Try:

=1-AND(C1=Sheet1!C1,C2=Sheet1!C2)

So in EH13, you want
=IF('sheet 1'!D1 = 'sheet 2'D1, 0,1)
and in EH1, same thing
=IF('sheet 1'!D2 = 'sheet 2'D2, 0,1)
Is that what you are looking to do?

Why did you rename this thread to Cancel?

OK I will close this 1, can you give me the link to the other 1 please?

OK I think it was this 1, let me know if Im wrongh?
https://www.excelforum.com/excel-for...s-a-value.html