I have a range 100 rows and 5 columns. I want to match pattern of 5 columns in a row. Data and pattern have duplicates and there is no sequence or sorting creteria. Data and pattern are random. Iwant to return if a certain pattern ‘matches’ with any rows in range.

Thanks.

Data Range sample:

Pattern to match:

Result: It should return match at row three in the range.

CodePudding user response：

Try using:

=IF(CONCAT(B2,C2,D2,E2,F2)=J2,"Match Found",0)

You can