Excel Forum
Similar Content
Reference Other Excel Files with Formulas and Functions
Tutorial: In Excel you can use formulas and functions to reference data that is stored in another Ex...
Best Lookup Formula in Excel - Index and Match
Tutorial: A lookup using INDEX and MATCH is like a VLOOKUP without the restrictions.  Index and Mat...
HLOOKUP in Excel
Tutorial: The Hlookup function allows you to scan a row from left to right in search of a value and ...



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





Got a Question? Ask it Here in the Forum.