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!
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.
User | Count |
---|---|
37 | |
30 | |
29 | |
20 | |
18 |