Return mail adress on two conditon (search in enumlist)

[Atlas]

Trying to write an expression for a  To section in a "send an email" task for the "ORDERS" table, to send an email to the "PROJECT MANAGER" when new orders are added.

I can get the mail address of the project manager with the expression below.

ANY(SELECT(STAFF[E-MAIL],[POST] = "PROJECT MANAGER")

I want to add also a condition because I don't want to send an email to all project managers.

In my "STAFF" table, I have a enumlist type column called [PROJECT]. 
In the "ORDERS" table [SITE]  column comprise the values of [PROJECT].

How to make an expression to get the mail address of the project manager from the "STAFF" table who is appointed the [SITE], in the "ORDERS" table.

I also tried to combine two expression below but I did't make it combined. 

ANY(SELECT(STAFF[E-MAIL],[POST] = "PROJECT MANAGER")
IN([SITE],
SPLIT(LOOKUP(USEREMAIL(),“STAFF”,“E-MAIL”,“PROJECTS”)," , "))

Thank you for your time in reading this issue.

[TeeSee1 · Accepted solution]

Try

SELECT(
 STAFF[E-MAIL],
 AND(
  [POST] = "PROJECT MANAGER",
  IN(
   [_THISROW].[SITE],
   [PROJECTS]
  )
 )
)

[Atlas]

God bless you sir!
Thank you so much!