Est. 2002
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.
At Computer Tutoring, we prioritise your privacy and only collect the necessary information to provide our services. We will only share the personal data you provide in a form if you have opted in for those services. Our website also uses Google Analytics. You have the right to access, amend, or request deletion of your personal data by contacting us at info@computertutoring.co.uk.
For more details, please read our full Privacy Policy.