Hi all

I know how to filter a result if A = A

i.e.

Table1.filter(“A”=“A”).result

But what if the the column has more than one result i.e. A, B, C

“A” = “A” will no longer work

I’ve tried “A”.contains(“A”, “B”, “C”)

But the next column in line depends on the result of this one:

i.e. if A=A show 1, if B=B show 2, if C=C, show 3.

If I use .contains()

“A”.contains(“A”, “B”, “C”) will show 1, 2 and 3 because A, B and C are contained in that column

It need an exact match, it doesn’t work if its ‘true’.

I tried using lookup but I can only lookup one column, I need to lookup multiple columns.

Thanks