Can't get simple Lookup to Work and populate form

[ConnieMaldonado]

At least I think it’s simple.
Here’s the syntax:
LOOKUP(“Tech Email”, “Tech”, “Email”, “Tech ID”). Ah! So frustrated. The minute I think I understand it…

[1minManager · Accepted solution]

Assuming the green table is called Users

Any(Select(Users[Tech ID],[Email]=[_ThisRow].[Tech Email]))

[ConnieMaldonado]

Hallelujah. That worked! Thank you.

[1minManager]

Read about the other options here - https://help.appsheet.com/en/articles/961274-list-expressions-and-aggregates

help.appsheet.com is your friend

Simon@1minManager.com

[ConnieMaldonado]

Wow! Thank you.