Hi all
Need to check if both matches are on the same row
=row(A6)=row(B6)
which works, but i need it nested within my other formula
=IF(AND(COUNTIF(INDIRECT("'["&$F$1&"]"&$E$1&"'!$A:$M"),A6),COUNTIF(INDIRECT("'["&$F$1&"]"&$E$1&"'!$A:$M"),B6)),"Match","No Match")+
Cant work it out, could anyone assist?
Need to check if both matches are on the same row
=row(A6)=row(B6)
which works, but i need it nested within my other formula
=IF(AND(COUNTIF(INDIRECT("'["&$F$1&"]"&$E$1&"'!$A:$M"),A6),COUNTIF(INDIRECT("'["&$F$1&"]"&$E$1&"'!$A:$M"),B6)),"Match","No Match")+
Cant work it out, could anyone assist?