Template
Lookup Function
How to use the LOOKUP function
Industry:
n/a
This app shows how to use the LOOKUP function. Try entering an email address and see the corresponding email and color get filled in.
Loading...
Also see:
tablet mode & fullscreen mode
How we built this app
We use two lookup formulas in this example:
LOOKUP([Chosen Email], "Lookup Table", "Email", "Name")
LOOKUP([Chosen Email], "Lookup Table", "Email", "Color")
These functions find the row of "Lookup Table" whose "Email" column equals the email address entered by the user. Then, it returns the "Name" or "Color" value for that row.