How can I find A&B matches in C&D without using concatenate.
Example: Find matches between A&B and C&D
A B C D E
1 GARDEN STATE WINDY CITY NA
2 NICKLE DIME CARBON COPY 4
3 INDIANA JONES CANDY WRAPPER NA
4 BE THERE NICKLE DIME 5
5 SINGLED OUT BE THERE NA
the above found 2 matches. NICKLE DIME was a match in 4C&D
and BE there was a match in 5C&D. Is there a way to do this without
first using concatenate A,B and then C,D followed by the MATCH?
Example: Find matches between A&B and C&D
A B C D E
1 GARDEN STATE WINDY CITY NA
2 NICKLE DIME CARBON COPY 4
3 INDIANA JONES CANDY WRAPPER NA
4 BE THERE NICKLE DIME 5
5 SINGLED OUT BE THERE NA
the above found 2 matches. NICKLE DIME was a match in 4C&D
and BE there was a match in 5C&D. Is there a way to do this without
first using concatenate A,B and then C,D followed by the MATCH?