Valid If Problem

Ron_Mansolo
Participant IV

I need a valid if expression that checks if an input to a question exists in a column in a different sheet.

I am sure it is an easy expression that Iโ€™m just missing.

0 1 221
1 REPLY 1

If there is no direct relationship between the AppSheet tables, then you can likely use a LOOKUP() function and check that the result ISNOTBLANK(). So:

ISNOTBLANK(
      LOOKUP([Value to Lookup], "Lookup Table", "Match Value",  "Value to Return")
)
Top Labels in this Space