Associate a worker and his email to USEREMAIL()

[anonymous]

Hi there,

I’m trying to find the right formula, that matches the name of the worker with his associate Email and check if it is the person who is logged at the moment.

USEREMAIL()=LOOKUP(USEREMAIL();“Workers”;“Email”;“Email”)

Am I even close?

Thank you,
Rodrigo.

[anonymous]

Wouldn’t something like this work?:
IF(USEREMAIL() = [Name of Table].Email, Do something if True, Force Them to Login if False)

Basically using a IF statement to make it work.

[Steve]

Try:

IN(USEREMAIL(), Workers[Email])