Formula to match names in two columns and copy team number in next column

Sorry if the subject is confusing. I have an excel spreadsheet with a list of names (List 1). In another spreadsheet I have a another list of names with their team number (List 2). There is an overla...