Conditional show on a sheet

[francisvandergr]

USERID='SEGERS' or
USERID='ADMIN'

I have used this conditional show on my sheet. It works for SEGERS but not for Admin. When i do ADMIN first and then SEGERS, it works good for ADMIN. How is my formula for more users ?

[pat_agen]

hi,

try

if(match(USERID,'SEGERS','ADMIN')>0,1,0)

that should work and the afterwrads youjust add other userids.

[Miguel_Angel_Baeyens · Accepted solution]

Hello Francis,

Try the following:

MATCH(USERID, 'SEGERS', 'ADMIN')

That will return greater than zero if there is a match, otherwise zero.

Hope that helps.

[francisvandergr]

Thnx it works !