Making sure multiple criteria on same row

[Cooki]

Hi all

My formula is developing nicely, but i need to add in one last check but cant quite think how to incorporate in, hope someone could help.

I need to be able to make sure that the matches im looking for are on the same row as each other.

My formula looks like this so far: =IF(AND(COUNTIF(INDIRECT("'["&$F$1&"]"&$E$1&"'!$A:$M"),A6),COUNTIF(INDIRECT("'["&$F$1&"]"&$E$1&"'!$A:$M"),B6)),"Match","No Match")

I just need to make sure that if a match is found, that all matches are on the same row as each other.

I know its something to do with the ROW function, but not sure how

Thanks

Rich