+ Reply to Thread
Results 1 to 3 of 3

Why can't I figure out this simple formula...???

  1. #1
    Forum Contributor
    Join Date
    01-12-2004
    Location
    Nebraska, USA
    MS-Off Ver
    Office 365
    Posts
    167

    Angry Why can't I figure out this simple formula...???

    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.....

  2. #2
    Valued Forum Contributor
    Join Date
    07-11-2004
    Posts
    851
    how about (in cell E2 and copied down)

    =IF(ISERROR(VLOOKUP(D2,schedule!$D$6:$E$9,2,FALSE)),IF(ISERROR(VLOOKUP(D2,schedule!$J$6:$K$9,2,FALSE)),"Team Result Not Listed",VLOOKUP(D2,schedule!$J$6:$K$9,2,false)),VLOOKUP(D2,schedule!$D$6:$E$9,2,false))
    not a professional, just trying to assist.....

  3. #3
    Forum Contributor
    Join Date
    01-12-2004
    Location
    Nebraska, USA
    MS-Off Ver
    Office 365
    Posts
    167

    Thumbs up

    That works perfectly...Duane!!!.....

    I never considered using VLOOKUP across two separate ranges, like that.

    Instead, I was trying different combinations of INDEX and MATCH.

    Thank you, so much, for your quick and helpful response...!!!.....

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1