I have a list of teams in column B. In a tab called Division I have 6
division names with the teams listed in their respective division. I want
column C to enter the appropriate division name for the division the team is
in.

For example, I want column C to be labelled as AL EAST when column B has BOS
in it. How do I do this? Thank you.