actually it gives me BOS now. BOS is in cell A3 on the Division Tab.
"Bob Phillips" wrote:
=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.
|