Similar Content
Get Text from Comments in Excel Including the Author of the Comment - UDF
Macro: Output all text from a cell comment, including comment author, with this UDF in Excel. Thi...
Best Lookup Formula in Excel - Index and Match
Tutorial: A lookup using INDEX and MATCH is like a VLOOKUP without the restrictions.  Index and Ma...
Return the Min or Max Value Using a Lookup in Excel - INDEX MATCH
Tutorial: Find the Min or Max value in a range and, based on that, return a value from another rang...

# Highline Excel Class 44: Basics of INDEX & MATCH functions

Learn 1-way, 2-way & 3-way lookup using the INDEX and MATCH functions see these tricks:
1.Two-Way lookup (2 way Lookup, Two Way Lookup)
2.1-Way Lookup: Lookup Column to Left
3.1-Way Lookup: (Row #): lookup column and criteria row (number of elements must be the same)
4.1-Way Lookup: (Row #): lookup row and criteria column (number of elements must be the same)
5.1-Way Lookup: (Row #): lookup row and criteria column (number of elements must be the same), but column_num is put into row_num argument.
6.3-Way Lookup: Row, Column, Table (area) (INDEX & 3 MATCH functions in one formula)
7.3-Way Lookup: Name Three 3 tables one name (Define Name)

Related videos: Highline Excel Class 45: INDEX function & MATCH function 12 Unusual

This is a beginning to advanced Excel class taught at Highline Community College by Mike Gel excelisfun Girvin Busn 214 BTech 109

Got a Question? Ask it Here in the Forum.