Loading...

Highline Excel Class 42: Versatile LOOKUP function 10 Examples

16,014 views

Loading...

Loading...

Transcript

The interactive transcript could not be loaded.

Loading...

Loading...

Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on May 24, 2009

Download Excel file: http://people.highline.edu/mgirvin/ex...

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

  • Category

  • License

    • Standard YouTube License

Loading...

Advertisement
When autoplay is enabled, a suggested video will automatically play next.

Up next


to add this to Watch Later

Add to

Loading playlists...