Assuming your division names are in A1:C1 and teams are
in the 5 rows below each division (A2:C6), then try:
=OFFSET(divisions!A1,,MAX(IF(ISNUMBER(SEARCH(B2,di visions!
A1:C6)),COLUMN(divisions!A1:C6)))-1,)
Array-entered, meaning press ctrl + shift + enter.
HTH
Jason
Atlanta, GA
-----Original Message-----
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.
.
|