Index Match help
Results 1 to 5 of 5

Thread: Index Match help
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jul 2019
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Index Match help

    Hi!

    I have a formula (below) that is working when I use the exact term I want to look up (DEN C) but I would like to look up anything that starts with DEN. There should be three possible options, DEN S, DEN C, and DEN F.

    {=INDEX(E:E,MATCH(1,(Withholdings!A:A=Data!A2)*(Withholdings!F:F="DEN C"),0))}

    Suggestions would be extremely welcome.

    Thank you
    L

  2. #2
    Board Regular
    Join Date
    Dec 2017
    Location
    UK
    Posts
    827
    Post Thanks / Like
    Mentioned
    35 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Index Match help

    Have you tried using the "Left" function?
    Speed up your code use variant arrays and NEVER ACCESS THE WORKSHEET IN A LOOP

  3. #3
    Board Regular
    Join Date
    Oct 2011
    Posts
    4,225
    Post Thanks / Like
    Mentioned
    11 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Index Match help

    It would help if you would post a small sample of your data, but maybe:

    Code:
    =INDEX(E:E,MATCH(1,(Withholdings!A:A=Data!A2)*ISNUMBER(SEARCH("DEN"&" ?",Withholdings!F:F)),0))
    There is only one space between " ?"
    Last edited by AhoyNC; Jul 10th, 2019 at 03:52 PM.

  4. #4
    New Member
    Join Date
    Jul 2019
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Index Match help

    AhoyNC - I have only sampled a small test group but that has completely solved my problem

    Thank you so much!

    L

  5. #5
    Board Regular
    Join Date
    Oct 2011
    Posts
    4,225
    Post Thanks / Like
    Mentioned
    11 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Index Match help

    You're welcome. Thanks for the feedback and welcome to the forum.

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
  •