Simple Find Values?

Originally Posted by DonkeyOte

If we assume

Sheet1!A1: 4112JJPV

Sheet2!A holds 6 chars and B 2 chars

Sheet1!B1:
=ISNUMBER(LOOKUP(2,1/(Sheet2!$A$1:$A$100&Sheet2!$B$1:$B$100=$A1)))

TRUE means match found.

D.O:

Would you mind explaining the breakdown of that LOOKUP for me please? Is it evaluating and comparing the whole range in one go somehow?

Thanks