Computer Tutoring Logo
Est. 2002
Menu Button

Excel Index Match - Computer Tutoring


If VLookup won't cut it then the Index Match function goes to places that VLookup just won't dare to go. The Excel Index Match function is infact two functions. One called Index and One called Match

So in the above example the formula would be:

=INDEX(A:A,MATCH(J2,C:C,0))

If this seems a little bit confusing then you might want to take a look at the INDEX Function video.

Excel Index Match exercise file

You may have to click on enable editing in Excel to be able to complete the exercise.