Excel Forum



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.