Main Profile

At A Glance

Excel Lookup Series #11: INDEX & MATCH functions Two 2 Way Lookup

See how to use the INDEX & MATCH functions together 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, and you don't even have to count the number of columns or rows!!! See how to locate a payroll tax with a 2-way lookup (Income and Allowances) Two 2 Way Lookup YTL Excel #119: Amazing Lookup Solution! Excel Lookup Series #11: INDEX & MATCH functions Two 2 Way Lookup Excel Name Trick #7: INDIRECT function, Names and LOOKUP Mr Excel & excelisfun Excel Trick #1: Two 2 Way Lookup MrExcel's Learn Excel #965 - Two-Way Lookup Excel Magic Trick #136: Two 2 way lookup with VLOOKUP & MATCH 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.
Length: 04:46

Contact

Questions about Excel Lookup Series #11: INDEX & MATCH functions Two 2 Way Lookup

Want more info about Excel Lookup Series #11: INDEX & MATCH functions Two 2 Way Lookup? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question