Pre-Populate a form based on Multiple criteria lookup

[nickerson18]

I'm trying to pre-populate a form using a multiple criteria lookup, ie a Where clause with 2 conditions.  Thank you in advance for your help!

[Markus_Malessa]

Sounds like a LOOKUP() function with an AND() function probably in the 'value' clause? I have not tried this nor do I know if it would function that way but I would think like this LOOKUP(AND('do your two conditions here'), dataset, column, return-column). Otherwise I would probably suggest ANY(SELECT()) and include your where clauses in the SELECT() formula.