How to use INDEX function in Excel
Written By: admin on March 7, 2010
14 Comments
See how to use the INDEX function to lookup something in an excel table given a row position and column position. You can look something up at the intersecting cell given a row number and column number! Watch a video tutorial on how to locate a payroll tax with a 2-way lookup (Income and Allowances)








Use the keyboard shortcut to open the Insert Function dialog box:
Shift + F3
Then with the “Or select a category” Textbox drop-down arrow, select “Statistical”.
how can I display a list statistical function
I am glad that it helped!
hey!..i got excel exam today!…this helps alot!!thakx to u men!!
Dear alaaahmed,
I am glad that you like it!
–excelisfun
man i from Egypt and i really liked you tut very much, keep the great work.
salaam
Dear quirky524,
The special effects helps to make it fun and the useful tricks help to get the job done faster!
–excelisfun
I like the special sound effects you give like Brrrruuuuuppppppp, etc. Keep it up good job.
Dear harish6sha ,
I am glad that you find them useful (cool)!
–excelisfun
Your videos are cool ,Thanks for your work.
Dear shiryu008,
Two-way look is a very important Excel trick!
–ExcelIsFun
Index combiend with match is very powerfull!.
Dear choliman,
I am happy to make videos for our YouTubeExcelTeam!!!!!!
–ExcelIsFun
Hola ExcellsFun!!! Grande!!! sos lo maximo!!! tus videos estan muy bien hechos, y divertidos, un saludo desde Guatemala.
Thx you’r videos are great!!! thanks againg