Excel Lookup Series #9: INDEX function 1st Example

See how to use the INDEX function to lookup something in a table given a row position and column position. Yes, it's true: You can look something up at the intersecting cell given a row number and column number!

See how to locate a payroll tax with a 2-way lookup (Income and Allowances)

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
• Index
• intersecting
• cell
• row
• column
• Formula
• Mike
• Gel
• Girvin
• Highline
• Community
• College

[pariskhan]

u made my day..thanks a million



[ExcelIsFun]

You are welcome!

[Shokukumi]

Helped a lot, thank you. Also easy to understand.

[ExcelIsFun]

You are welcome!

[celulito]

Hey thanks a lot! :D Great videos!

[ExcelIsFun]

You are welcome!

[hacksign000]

thanks, I get it now

[ExcelIsFun]

You are welcome!

[celulito]

HEEY! thanks a lot, great video

[ExcelIsFun]

You are welcome!