Making sure multiple criteria on same row

Cooki

Board Regular
Joined
Jul 31, 2018
Messages
70
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
 

Some videos you may like

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Watch MrExcel Video

Forum statistics

Threads
1,114,651
Messages
5,549,204
Members
410,905
Latest member
Extjel
Top