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...
Vlookup on Dates and Times in Excel
Tutorial: Perform a lookup on dates and times in Excel: vlookup, hlookup, index/match, any kind of l...

Excel Lookup Series #7: LOOKUP Function

See how to use the LOOKUP function! We all know how to use VLOOKUP, but how do we use LOOKUP? See how to use LOOKUP to find a value to the left of the lookup column. See how to use the LOOKUP function to lookup values anywhere in the sheet (not just a table).

In this Series learn 15 amazing ways to look things up in Excel. We will look at the functions VLOOKUP, HLOOKUP, LOOKUP, MATCH, INDEX, CHOOSE, and the non-function lookup formula using the intersector operator. We will look at simple lookups all the way to complicated, yet efficient methods to look things up in Excel.

This is a logical (beginning to end) story about most of the lookup situations you may encounter in Excel.

Got a Question? Ask it Here in the Forum.