Excel Lookup Series #10: INDEX function 2nd Example

See how to use the INDEX function to look up a value from multiple tables. See how to use the INDEX function to indicate a row position, a column position, and 1 table amongst various tables! Amazing!

In this Series learn 15 amazing ways to look things up in Excel. We will look at the functions VLOOKUP, HLOOKUP, LOOKUP, MATCH, INDEX, CHOOSE, and the non-function lookup formula using the intersector operator. We will look at simple lookups all the way to complicated, yet efficient methods to look things up in Excel.

This is a logical (beginning to end) story about most of the lookup situations you may encounter in Excel.

Category:

Science & Technology

Tags:

• Excel
• INDEX
• function
• formula
• to
• look
• up
• value
• from
• multiple
• tables
• Mike
• Gel
• Girvin
• Highline
• Community
• College

[kingtickler]

best excel tutorials on the internet hands down. i'm so happy i don't have to sit through other lame videos anymore. thanks a lot!

[ExcelIsFun]

@kingtickler , I am glad that you like them and that they are helpful!

[Berean50]

Mike, you have a way to vulgarize that is rendered comprehensive to the most illiterate! We feel the passion that you have for Excel and that shows in the quality of your lessons. Thanks a million!

[ExcelIsFun]

@Berean50 , thank you! I am glad that the videos help!!!

[leok31]

Dude...why am I paying $3k for go to uni and study this class! 10min of your video = 1 hour of lecture!

[ExcelIsFun]

I am glad that it helps!

[donmac1963]

@TheLonelymusic Go to ORB Button > Excel Options > Advanced and make sure that "Enable Fill handle and Cell Drag & Drop" is checked.

[theretherebemonsters]

@leok31 Maybe your paying 3k to improve your grammar???

[ExcelIsFun]

I have no idea what could be causing the problem. The best place to ask Excel questions is Mr Excel Message Board:

mrexcel[dot]com/forum

[TheLonelymusic]

In excel 2007 cursor always in standard selection ,i cant get (+) this cursor when i placed the cursor below the right of my cell. i wanna make series and other access .how to get ( +cursor ) symbol .please tell me