I cant put the lookup function to work..i hav...

(Essi Quezon) #1

I cant put the lookup function to work…i have a form view. I wnt the app to response to user entry data by returning records that matches the user entry value. But the app keeps on displying the firts record even the entry form is empty.

What’s my best option to mke it work??

(Fernando López) #2

Write your formula please

(Steven Coile) #3

LOOKUP() will only ever return a single column value from a single row. To return a list of column values from select rows, use SELECT().

(Steven Coile) #4

LOOKUP() help.appsheet.com

(Steven Coile) #5

SELECT() help.appsheet.com