Using the IN() with LIST() and SELECT()

[AdemarN]

IN(
    [E-mail Address], 
    LIST(
            SELECT(Linked Emails[Linked Email], USEREMAIL() = [Login User Email])
           )
   )

It only returns results for the first row it finds in the select statement and ignores any additional rows from the select results. Any thoughts on how I could make it work?

Thanks