Simple FILTER by Team column. Wrap it by CHOOSECOLS to extract needed columns:
FILTER
CHOOSECOLS
=CHOOSECOLS(FILTER($A$2:$E$4,$E$2:$E$4=B7),1,2,4)
Adapt to your ranges.