Read text in one cell and fill another

[Double_D]

Hi,

So I am trying to create a Fantasy Football spread sheet. I want to create a formula that will read the team name in the cell next to it and then spit out the bye week that team has assigned. For example if E4="ARI" then I want F4=8 for their bye week being week 8.


While it is easy to make it for one word like ARI and spit out 8. Is there a way to output the week number with the corresponding team initials.

The team initials and bye weeks are:
ATL, DEN, NO, WAS = 5
BUF, CIN, DAL, SEA = 6
DET, HOU = 7
ARI, GB, JAC, LAR, NYG, TEN = 8
CHI, CLE, LAC, MIN, NE, PIT = 9
BAL, KC, OAK, PHI = 10
CAR, IND, MIA, NYJ, SF, TB =11

 

[jarjarbingie]

Hi,

So I am trying to create a Fantasy Football spread sheet. I want to create a formula that will read the team name in the cell next to it and then spit out the bye week that team has assigned. For example if E4="ARI" then I want F4=8 for their bye week being week 8.


While it is easy to make it for one word like ARI and spit out 8. Is there a way to output the week number with the corresponding team initials.

The team initials and bye weeks are:
ATL, DEN, NO, WAS = 5
BUF, CIN, DAL, SEA = 6
DET, HOU = 7
ARI, GB, JAC, LAR, NYG, TEN = 8
CHI, CLE, LAC, MIN, NE, PIT = 9
BAL, KC, OAK, PHI = 10
CAR, IND, MIA, NYJ, SF, TB =11

create a mapping table with 2 columns: (1) Team Initial, (2) Bye Week then use this formula in F4:

=VLOOKUP(E4,mapping table,2,false)