1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.
Ted French

Excel INDEX Function

By March 29, 2014

Follow me on:

The INDEX function uses row and column numbers from an array to return the name of a specific item of data in an Excel database or table of data.

INDEX is often combined with other lookup functions, such as the MATCH function, to create versatile lookup formulas.

To find out all the details on how this function works, read this short tutorial on the Excel INDEX Function.



Related Tutorials
Comments
April 8, 2014 at 7:30 am
(1) Roger Menting says:

Hi,
I am not sure what I need. I would like to make bank repayment schedule. I think this is a spreadsheet, but the last time I tried spreadsheets; I was lost in three lessons.
Thanks,
Roger

April 22, 2014 at 2:16 pm
(2) venkat says:

Index formula very important to know, you can analyze very complicating data easily.

Leave a Comment

Line and paragraph breaks are automatic. Some HTML allowed: <a href="" title="">, <b>, <i>, <strike>

©2014 About.com. All rights reserved.