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

[Essi_Quezon]

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_Lopez1]

Write your formula please

[Steven_Coile]

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]

LOOKUP() help.appsheet.com

[Steven_Coile]

SELECT() help.appsheet.com