Discrepancy in Email Match Results Between Two Tables Explained

Hi, I have two tables: "ABC Table" and "XYZ Table." I used the "Lookup Single Row in Other Table" enrichment in the "ABC Table." Now, I am checking for email matches in the "XYZ Table." When I tested it for a single cell, it successfully found a record. However, when I ran it for 80 rows at once, the output showed "No record found," even though there is a matching record in the "XYZ Table." Why is there such a discrepancy? Is there an alternative solution for this?