Show Specific row for each user

[MohamedSalem999]

Hello Everyone,

I have two table 
First Table name: Report malfunctions
The Second Table Name: User Role
I give every user some role at table "User Role"

at first table the users just applied some malfunctions and show like this:

i want to show every specific row for the Responsible for type Equ. like:

- If user has role Engineer i just want to show him Type equ. = "BM"

- If user has role Technician i just want to show him Type equ. = "Other"

[TeeSee1 · Accepted solution]

SECURITY FILTER or SLICE

Try something like

SWITCH(
 LOOKUP(USEREMAIL(), "User Role","Email","Role"),
 "Engineer", [Type Equ] = "BM,
 ....
)

[MohamedSalem999]

Thank you for help but i have issue 

at third case "Stuff", [Type EQU.] = "MG"
He just shows the second how can i make it to show both EM & MG
@TeeSee1 

[TeeSee1]

Use OR() or IN()