=INDEX(Division!A:A,MATCH(B1,Division!B:B,0))
etc.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jambruins" wrote in message
...
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.