Results 1 to 8 of 8

Thread: Vlookup with 2 conditions

  1. #1
    Board Regular
    Join Date
    Feb 2013
    Posts
    56
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Vlookup with 2 conditions


    Beginning in Column H3, based on the value in column G3, I want to return the starting goalie for the game.

    So for game 1 I want to return "Pekka Rinne", Game 2 "Jusse Saros" from the array $A$3:$D$12

    The linked picture of the example sheet, the eventual array will be 2000 rows.

    https://imgur.com/a/yOdTpT9

    thanks



  2. #2
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    29,067
    Post Thanks / Like
    Mentioned
    483 Post(s)
    Tagged
    48 Thread(s)

    Default Re: Vlookup with 2 conditions

    How about
    =INDEX($D$3:$D$13,MATCH(G3&"|G",INDEX($A$3:$A$13&"|"&$C$3:$C$13,0),0))
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

  3. #3
    Board Regular
    Join Date
    Feb 2013
    Posts
    56
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Vlookup with 2 conditions

    Hey again Fluff, can you make it simple for me, instead of the example make the array $A$3:$D$2500. The game # and the return cell for the result is the same.

    Thanks
    Last edited by John_Wh; Oct 16th, 2019 at 02:50 PM.

  4. #4
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    29,067
    Post Thanks / Like
    Mentioned
    483 Post(s)
    Tagged
    48 Thread(s)

    Default Re: Vlookup with 2 conditions

    I'm sorry but I don't understand what you mean.
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

  5. #5
    Board Regular
    Join Date
    Feb 2013
    Posts
    56
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Vlookup with 2 conditions

    In the image in the first post the table is from $A$3:$D$12

    The actual table is $A$3:$D$2500

  6. #6
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    29,067
    Post Thanks / Like
    Mentioned
    483 Post(s)
    Tagged
    48 Thread(s)

    Default Re: Vlookup with 2 conditions

    Ok, in that case use
    =INDEX($D$3:$D$2500,MATCH(G3&"|G",INDEX($A$3:$A$2500&"|"&$C$3:$C$2500,0),0))
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

  7. #7
    Board Regular
    Join Date
    Feb 2013
    Posts
    56
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Vlookup with 2 conditions

    Thanks again, you've been helpful several times over the years!

  8. #8
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    29,067
    Post Thanks / Like
    Mentioned
    483 Post(s)
    Tagged
    48 Thread(s)

    Default Re: Vlookup with 2 conditions

    Glad to help & thanks for the feedback
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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