I would set up a table with the Team name in the 1st column and the division
in the 2nd. Say you put this in K1:L15. Note that the single table contains
all teams from all divisions.

With BOS in B2, in C2 you write the formula =VLOOKUP(B2,$K$1:$L$15,2,0)


On Mon, 21 Feb 2005 12:41:05 -0800, Jambruins
wrote:

Can I setup an IF statement to select between 3 options? For example, I have
3 divisions with 5 teams in each division. Can I setup a formula to have it
enter the proper division if I have the team name entered. For example, if I
have BOS in cell B2 how do I get cell C2 to say AL EAST. I have a tab called
divisions with the divisions listed in cells A1, A2, and A3. The teams from
division A1 are listed in cells A2, A3, A4, A5, and A6. Thanks.