Computer Tutoring Logo
Est. 2002
Menu Button

Excel Index Match

Share

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


Computer Tutoring takes your privacy seriously and collects essential information such as your name, email, and course preferences to facilitate our services. Additionally, we use cookies to personalise your experience and for Google Ads personalisation, which helps us deliver more relevant advertising to you.

We do not share your personal data, except for specific use-cases like payment processing via PayPal and sending you updates via Mailchimp, if you've opted in for those services. Our site may also use Google Analytics to improve user experience and features links to other websites. Please be aware that Google's Privacy Policy may differ from ours.

We do not store your credit/debit card details. You have the right to access, amend, or request deletion of your personal data by contacting us at info@computertutoring.co.uk.

By using our website, you consent to our use of cookies for the purposes outlined above.

For more details, please read our full Privacy Policy.