shorten switch list

Hi, is there a way to shorten the following switch list of sellers and coordinators?

I have tried but has not worked

 

SWITCH(USEREMAIL(),
INDEX(INTERSECT(list(useremail()),Sellers[Email]),1,),"ALL_CHANGES",
INDEX(INTERSECT(list(useremail()),coordinators[Email]),1,),"ALL_CHANGES",
"READ_ONLY")

 

Thanks 

Solved Solved
0 3 118
1 ACCEPTED SOLUTION

How about.. IF(IN(USEREMAIL(),Sellers[Email]+Coordinators[Email]),"ALL_CHANGES","READ_ONLY")

View solution in original post

3 REPLIES 3

How about.. IF(IN(USEREMAIL(),Sellers[Email]+Coordinators[Email]),"ALL_CHANGES","READ_ONLY")

@AleksiAlkio  Hello and sorry for being late

yes perfect, Thank you very much

You're welcome!