Match Col A data with Col B data

[#1]

I would like to ask what formula I can put in Column 3 to get this kind of data?
Means if any row of Column 2 data includes data of Column 1, then the row will print out "Y" at column 3. If there's no related value in Column 2, then the row will print out "N"

[#2 · Accepted solution]

Hi,

Here is a simple way to get your result (see attached table)

var_r = :REFERENCE << Get Values;
If( Contains( var_r, :QUERY ),
	"YES",
	"NO"
);

It works for both Numerical and Character values.

Best,

TS

[#3]

Thx !!! It's working