Finding Matches on Multiple Sheets with Multiple Criteria

[criner5]

I'm trying to find if two criteria on one sheet match the same criteria on another sheet. Every time I get a formula it shows False but I know some are True.

I'm trying to determine if the value in column J and column M are repeating in a row on another sheet for a series of 13

My latest attempt is: =IF(AND($J7='520-15402'!$J$2:$J$150, $M7='520-15402'!$M$2:$M$150), "True", "False")

 

[Habtest]

Hi, try this:

=ISNUMBER(MATCH($J7,'520-15402'!$J$2:$J$150,0)+MATCH($M7,'520-15402'!$M$2:$M$150,0))