Help - Matching Football Team with Bye week

**phillyfan** · 08-21-2009, 06:12 PM

I am adjusting a spreadsheet for a fantasy football draft and want to have one column which will have the player's team. The next column I want the bye week for that player to automatically populate.

For example:

A1 - Tom Brady
A2 - NE

In A3 I want a formula like

If A2 = ari, atl, car, phi then 4
If A2 = chi, gb, no, sd then 5
...
If A2 = cin, kc, ne, pit, tb, was then 8

etc..

Obviously the condition only needs to satisfy one of the teams.

Any help appreciated.

Thanks

**JBeaucaire** · 08-21-2009, 07:03 PM

Use a lookup table. In your sheet somewhere (Sheet2?) create a two-column list with the team abbreviation in the first column (Sheet2 column A) and the numeric result in the second column (column B).

Then in cell A3, use a standard VLOOKUP() or INDEX/MATCH
=VLOOKUP(A2, Sheet2!$A$1:$B$200, 2, FALSE)
=INDEX(Sheet2!B:B, MATCH(A2, Sheet2!A:A, FALSE))

**phillyfan** · 08-21-2009, 07:29 PM

Much thanks. Does the trick.

**JBeaucaire** · 08-21-2009, 07:34 PM

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].

(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)