'Match the values in google sheets from another sheet
I need for my two data sets to find exact match.
In sheet called set1 I need for it to look up results of set2 and if set1 sheet has a match with set2 sheet then print Match, otherwise no match.
Below is what I tried:
=INDEX(A:A,MATCH,set2!A:A)
Solution 1:[1]
use in row 1:
=INDEX(IF(REGEXMATCH(A:A; TEXTJOIN("|"; 1; set2!A2:A); "Match"; )
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | player0 |