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

expressions
(Elize de Beer) #1

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 [AppSheet]) #2

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