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 row in column B. E.g. in row 2, there is a match between value in column 1 (CN…385A) and column 2).

Ideally the output in column C would be “yes” or “match”. 

Ideally want to keep cells formatted as they are, with delimiters between patent numbers.

many thanks

​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 row in column B. E.g. in row 2, there is a match between value in column 1 (CN…385A) and column 2).Ideally the output in column C would be “yes” or “match”. Ideally want to keep cells formatted as they are, with delimiters between patent numbers. many thanks  Read More

​