Expression to find all items in a column

[alenb]

I have a table like this.

User, Team A, Team B

XY, admin, user

AB, user

I want to get for the User  which value it has for certain team. 

[Frank_Hartmann · Accepted solution]

try this in textbox:

=only({<User={'XY'}>}[Team A])

result will be "admin"