Security Filter OR Expression not working

[eddie61]

Hi all

I'm trying to set up a security filter that shows all the rows to our employees, but only shows the rows to employees of other companies, if it has their name in the row.

I'm using the following expression:

OR(LOOKUP(USEREMAIL(),User_DB,eMail,Company)="Selmoni Infranet",LOOKUP(USEREMAIL(),User_DB,eMail,Company)=[Company])

It works for all the accounts in the User_DB that have "Selmoni Infranet" in the "Firma" column. But the second "OR" expression doesn't give me any results, altough I do have matching company names in the Filtered table, and in the User_DB table.

Shouldn't this expression work?

Thanks in advance.

Adrian