Hi I'm using the LOOKUP expression to find a ...

[Elize_de_Beer]

Hi I’m using the LOOKUP expression to find a value in another table. The problem is there are more than one possible result in the other table so Appsheet randomly selects one of the possible values. How can I force it to select a particular value e.g the largest value? Thanks

[Gil_Littman_App]

If you use SELECT instead you’ll get a list of values. MAXROW can be used to get the greatest value from that list.