topic Re: Match Col A data with Col B data in Discussions

Match Col A data with Col B data

Sysy13 — Thu, 17 Aug 2023 00:41:05 GMT

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"

Re: Match Col A data with Col B data

Thierry_S — Thu, 17 Aug 2023 00:57:48 GMT

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,

Re: Match Col A data with Col B data

Sysy13 — Thu, 17 Aug 2023 07:10:26 GMT

Thx !!! It's working