Main Profile

At A Glance

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
Length: 23:02

Contact

Questions about Highline Excel Class 42: Versatile LOOKUP function 10 Examples

Want more info about Highline Excel Class 42: Versatile LOOKUP function 10 Examples? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question