Hi,

you need a helper column (in both sheets) that will concatenate values
from all columns you want to compare. Then lookup in the helper column.

Regards,
Ivan