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

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

Watch MrExcel Video

Forum statistics

Threads
1,114,663
Messages
5,549,295
Members
410,908
Latest member
Allen P
Top