Say Goodbye to VLOOKUP, and Hello to INDEX-MATCH | eImagine Technology Group

Posted on 2 January 2015 by matthannan

=INDEX(nodes.csv!$A$1:$A$31,MATCH(C2,nodes.csv!$B$1:$B$31,0))

Say Goodbye to VLOOKUP, and Hello to INDEX-MATCH | eImagine Technology Group.

This entry was posted in Geek and tagged . Bookmark the permalink.

3 Responses to Say Goodbye to VLOOKUP, and Hello to INDEX-MATCH | eImagine Technology Group

  1. neil fraser says:
    2 March 2015 at 2:07 PM

    Thanks great article I am really close , what do I need to change to return the first occurance in column AO , ?=SUMIF(AN:AN,”*”&AK4&”*”,AO:AO)
    Currently it is returning sum of line numbers ( contained in column AO ) , this is the closest I have found to giving me what I want

    Reply
  2. Jen Bil says:
    12 May 2015 at 11:33 AM

    I have a table with below data:
    A B C D E F
    a1 data1 a2 data2 a2 data 3
    b1 data1 a1 data2 a4 data 3
    c1 data1 c1 data2 b2 data 3

    From my above table, I would need to show that a1 is present in data1 and data2.
    a2 is present in data2 and data3
    b1 is present in data1
    a4 is in data3
    c1 in data1 and data2
    b2 in data3

    and so forth…

    Is this possible using Index/match? or any other function that would help attain such a result?

    Your help would be highly appreciated.

    Reply
  3. Mikkel Sciegienny says:
    2 February 2016 at 6:24 AM

    Hi Matt!

    I was just searching for some articles about index match in Excel and came across this page.

    Just thought you (and your reader) might be interested in our guide to INDEX MATCH that I’ve just published at: http://spreadsheeto.com/index-match/

    We tried to explain the process in a very user-friendly way, because it’s indeed a bit complex.

    Would love for you to check it out – and it might be worth a mention on your page 🙂

    Either way, keep up the great work!

    Cheers,
    Mikkel

    Reply

Leave a Reply to neil fraserCancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.