Lookup column based on "Created by" column

I have main list (image #1) for users to enter information, and the second list (image #2) with the users and their team name. In the main list, I like the Team column to be filled up automatically b...