Forum Discussion

zchahin's avatar
zchahin
Copper Contributor
Jul 27, 2024
Solved

Comparing two columns with comma separated string values (match)

Hi,    I currently have two columns of reference data. Each cell contains comma separated values.  My aim is to find a match between any of the patent numbers in column A within the corresponding ...
  • HansVogelaar's avatar
    Jul 27, 2024

    zchahin 

    In C2:

    =IF(OR(ISNUMBER(XMATCH(TEXTSPLIT(A2, "|"), TEXTSPLIT(B2, "|")))), "Match", "")

Resources