Don't know why I'm having so much trouble with this formula...![]()
What I want to do is quite simple. I have a worksheet containing TEAM NAMES in columns D & J. The columns to the right of those columns, (E & K) will contain data signifying a WIN or a LOSS, (specifically, a "W" or an "L"). The worksheet, named 'Schedule', looks like this:
................D.....................E......................J.................K
6....Denver Broncos..........W.....San Diego Chargers.....L
7....Dallas Cowboys...........L.....Washington Redskins....W
8....Seattle Seahawks........L......San Francisco 49ers.....W
9....Green Bay Packers......W.....Chicago Bears.............L
On a seperate worksheet, I have a list of teams selected by each player in a contest for a given week. In the column to the right of each team, I want the value to the right of the same team name on the 'Schedule' worksheet.
Using the example, above, I want THIS:
................D.......................E
2....Denver Broncos............W
3....Washington Redskins.....W
4....Seattle Seahawks..........L
5....Chicago Bears...............L
What formula should be entered into cells E2:E5, on the SECOND worksheet, to achieve this?
This should be so simple, but all my efforts return errors of one kind or another. ....![]()
Thank you, in advance for any help you can give me.....![]()
Bookmarks