Excel

Sum the text number

Vlookup not the first as reference

LOOKUP FORMULA

All team name put together