|
Featured Tutorial
Featured Macro
Highline Excel Class 42: Versatile LOOKUP function 10 Examples
See these 10 LOOKUP tricks
1.LOOKUP: 1) 1st column sorted ascending, 2) only does approximate lookup, 3) always returns value from last column / row, 4) can do V or H Lookup, 5) can have 2 vectors
2.More rows than columns: LOOKUP does vertical lookup
3.More columns than rows LOOKUP does horizontal lookup
4.See 3 LOOKUPS in one formula
5.Lookup values in two separate vectors
6.LOOKUP can handle arrays (like SUMPRODUCT)
7.Partial Text Lookup (lookup_value has more characters than in lookup_vector)
8.Partial Text Lookup (lookup_value has fewer characters than in lookup_vector)
9.Find Last Value in Column / Row
10.Conditional Format a row with LOOKUP function
This is a beginning to advanced Excel class taught at Highline Community College by Mike Gel excelisfun Girvin Busn 214 BTech 109
1.LOOKUP: 1) 1st column sorted ascending, 2) only does approximate lookup, 3) always returns value from last column / row, 4) can do V or H Lookup, 5) can have 2 vectors
2.More rows than columns: LOOKUP does vertical lookup
3.More columns than rows LOOKUP does horizontal lookup
4.See 3 LOOKUPS in one formula
5.Lookup values in two separate vectors
6.LOOKUP can handle arrays (like SUMPRODUCT)
7.Partial Text Lookup (lookup_value has more characters than in lookup_vector)
8.Partial Text Lookup (lookup_value has fewer characters than in lookup_vector)
9.Find Last Value in Column / Row
10.Conditional Format a row with LOOKUP function
This is a beginning to advanced Excel class taught at Highline Community College by Mike Gel excelisfun Girvin Busn 214 BTech 109