Auto Fillout Data


I want to be able to auto fillout the data, but I am not sure what formula to use. Please see the table below, so if someone clicked on the email column on the right, I want the Appsheet, to auto fill out that the Team is going to be Team 1 for example.