How to Use INDEX MATCH in Excel?
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 tutorial.
Excel Index Match exercise file
You may have to click on enable editing in Excel to be able to complete the exercise.