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

=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:

    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

  2. Jen Bil says:

    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.

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

Leave a Reply to neil fraserCancel reply

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