668674_en-US

liliconcom

Match Col A data with Col B data

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"

Basic Data Analysis and ModelingRe: Match Col A data with Col B data

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

Re: Match Col A data with Col B data

Thx !!! It's working