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!
There are currently 1 users browsing this thread. (0 members and 1 guests)
View Tag Cloud
Forum Rules
LinkBack URL
About LinkBacks
Originally Posted by DonkeyOte
Posting Permissions
Register To Reply
Bookmarks