How is it possible to compare cells in 3 columns of 2 different sheets? The rows will not necessarily match up, but the column data will, so if A, B & C match in any row in the 2 sheets, then it is a yes.
Let me explain.
Column A is the name of the league
Column B is the date and time of the match
Column C is the name of the match, like Barcelona - Real Madrid
So you can see that although A or C might be the same over a span of some years, matching the date as well will mean that it is a particular match
What I am trying to do is to find out if matches appear in both sheets. The result is to go in 1 of those sheets called Lay Under 15_25_35, but the other sheet, which is in the same workbook, is called Lay Over 2.5.
So what I am after is IF A in the destination sheet = A in 'Lay Over 2.5'! AND IF B in the destination sheet = B in 'Lay Over 2.5'! AND IF C in the destination sheet = C in 'Lay Over 2.5'! then put "YES" otherwise "NO"
I tried writing it, but as the rows will not be the same, was struggling to get it right.
I tried the following, but to no avail
This returned NO on all occasion, even though there were some matches which appeared in both
Any suggestions on how to improve this so it puts YES if A, B & C match in any row between the sheets?
cheers
Let me explain.
Column A is the name of the league
Column B is the date and time of the match
Column C is the name of the match, like Barcelona - Real Madrid
So you can see that although A or C might be the same over a span of some years, matching the date as well will mean that it is a particular match
What I am trying to do is to find out if matches appear in both sheets. The result is to go in 1 of those sheets called Lay Under 15_25_35, but the other sheet, which is in the same workbook, is called Lay Over 2.5.
So what I am after is IF A in the destination sheet = A in 'Lay Over 2.5'! AND IF B in the destination sheet = B in 'Lay Over 2.5'! AND IF C in the destination sheet = C in 'Lay Over 2.5'! then put "YES" otherwise "NO"
I tried writing it, but as the rows will not be the same, was struggling to get it right.
I tried the following, but to no avail
Code:
=IF(AND($A$2:$A2='Lay Over 2.5'!A2,$B$2:$B2='Lay Over 2.5'!B2,,$C$2:$C2='Lay Over 2.5'!C2),"YES","NO")
This returned NO on all occasion, even though there were some matches which appeared in both
Any suggestions on how to improve this so it puts YES if A, B & C match in any row between the sheets?
cheers