LinkBack URL
About LinkBacks
jdoerr1021 
in D2
=LOOKUP(NOT(ISNA(VLOOKUP(B2,A$2:A$30,1,0)))+NOT(ISNA(VLOOKUP(C2,A$2:A$30,1,0)))*2,{0,1,2,3},{"None","B","C","Both"})&" match"
and now
Output indicates whether none, column B, column C or Both match
in D2
=LOOKUP(NOT(ISNA(VLOOKUP(B2,A$2:A$30,1,0)))+NOT(ISNA(VLOOKUP(C2,A$2:A$30,1,0)))*2,{0,1,2,3},{"None","B","C","Both"})&" match"
and now
Output indicates whether none, column B, column C or Both match
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks