Simple Find Values?

**DonkeyOte** · 07-06-2009, 06:15 AM

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.

**James_C** · 07-06-2009, 06:32 AM

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.

Awsome tyvm!

**Phil_V** · 07-06-2009, 07:01 AM

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

**DonkeyOte** · 07-06-2009, 07:15 AM

Have a look at this similar thread in which I tried to provide a detailed explanation - hopefully it gives you the info you want ?

http://www.excelforum.com/excel-2007...-function.html