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.
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.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks