Filter based in another table

[lperal]

Hello,

I have a table where new entries are recorded, the user inputs the values for the columns Criteria 1, Criteria 2 and Criteria 3.

For Column Output, I am looking for an expression where based in the user input, it will look up for the desire output based on the references in another table:

[Steve · Accepted solution]

SELECT() - AppSheet Help

AND() - AppSheet Help

ANY() - AppSheet Help

[lperal]

Thank you Steve, I tried this expression but its working:

ANY(SELECT(Tables Reference[Output],AND([Criteria 1]=Tables Reference[Criteria 1],[Criteria 2]=Tables Reference[Criteria 2],[Criteria 3]=Tables Reference[Criteria 3])))

[Steve]

Go back and re-read the help doc carefully:

SELECT() - AppSheet Help

The answer is in there.