Excel Forum

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.