Hi.

Although it is possible to do this without any helper columns, to do so would require performing concatenations within the actual formulas themselves, which would then force those formulas to be committed as array formulas (or an equivalent construction using an extra INDEX function, which is no less resource-intensive).

Far better would be to use an additional column in each of your tabs and perform the concatenations in those, after which the formulas are straightforward and extremely efficient.

For example, in cell F2 of your Match tab, enter this formula:

=A2&"|"&B2&"|"&C2&"|"&D2&"|"&E2

and copy down.

In cell O2 of your Data tab enter this formula:

=F2&"|"&C2&"|"&I2&"|"&J2&"|"&N2

and copy down.

The formula in cell G2 of the Match tab is then:

=IF(ISNUMBER(MATCH(F2,Data!$O$2:$O$70,0)),"Yes","No")

Again, copy down as required.

Regards