Valid IF with 2 conditions based on other table

Good day,

I would like to ask for assistance I am new with appsheet.

I have 2 tables “Payments” and “User”

In “User” table there are 3 columns [Username], [Userrole] and [System Password]

In “Payments” table there are 8 columns. Two of the column [Username] and [System Password] are similar to “User” table.

What I want to achieve in valid if “Payments” table. The column [Username] in Payments table should match with User Table and the column [System Password] in “Payments” table should match the column [System Password] in “User” table.

Can someone suggest a expression?

Thank you

0 5 1,705
5 REPLIES 5
Top Labels in this Space