Dear people,
I have a question regarding the best way to work out the following problem:
I have a datatable in which the reference in columns A,B,C are (xx,yy,zz) - supposedly.
I need to check whether the same value occurs in columns X,W,Z.
The problem is that the number of the rows in columns A,B and C are dynamic. Sometimes it is only one rows as reference, sometimes more two or even three, for instance:
Columns: A B C
row(1): xx yy zz
row(2): ax ay az
These values must be used to check whether the values in rows of columns X,W,Z are one of those in the columns A, B and C (the value must be orderly correct and only refer to one row)
what is the best approach to do this?
Thank you in advance!