Home » Office

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)

Digg this!Add to del.icio.us!Stumble this!Add to Techorati!Share on Facebook!Seed Newsvine!Reddit!

14 Responses to “How to use INDEX function in Excel”

  1. ExcelIsFun on: 7 March 2010 at 10:17 pm

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

  2. MmaFighter510 on: 7 March 2010 at 10:35 pm

    how can I display a list statistical function

  3. ExcelIsFun on: 7 March 2010 at 11:05 pm

    I am glad that it helped!

  4. solinik on: 7 March 2010 at 11:27 pm

    hey!..i got excel exam today!…this helps alot!!thakx to u men!!

  5. ExcelIsFun on: 8 March 2010 at 12:02 am

    Dear alaaahmed,

    I am glad that you like it!

    –excelisfun

  6. alaaahmed on: 8 March 2010 at 12:42 am

    man i from Egypt and i really liked you tut very much, keep the great work.
    salaam

  7. ExcelIsFun on: 8 March 2010 at 12:44 am

    Dear quirky524,

    The special effects helps to make it fun and the useful tricks help to get the job done faster!

    –excelisfun

  8. quirky524 on: 8 March 2010 at 1:18 am

    I like the special sound effects you give like Brrrruuuuuppppppp, etc. Keep it up good job.

  9. ExcelIsFun on: 8 March 2010 at 2:11 am

    Dear harish6sha ,

    I am glad that you find them useful (cool)!

    –excelisfun

  10. harish6sha on: 8 March 2010 at 2:53 am

    Your videos are cool ,Thanks for your work.

  11. ExcelIsFun on: 8 March 2010 at 3:41 am

    Dear shiryu008,

    Two-way look is a very important Excel trick!

    –ExcelIsFun

  12. shiryu008 on: 8 March 2010 at 3:51 am

    Index combiend with match is very powerfull!.

  13. ExcelIsFun on: 8 March 2010 at 4:26 am

    Dear choliman,

    I am happy to make videos for our YouTubeExcelTeam!!!!!!

    –ExcelIsFun

  14. choliman on: 8 March 2010 at 5:07 am

    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

Leave a Reply:

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

  Copyright ©2009-2010 Best Indian Bloggers, All rights reserved.| WPElegance2Col theme by Techblissonline.com