Special

Excel Functions

2003-2010

Special

Excel Functions

2007-2010

Lesson 17: LOOKUP  Function In Excel

LOOKUP is a rarely used function and does not add any capabilities to a user who knows about VLOOKUP or HLOOKUP.

We will not offer you an example of a formula using the LOOKUP function because we strongly recommend that you forget about the three LOOKUP functions (HLOOKUP, LOOKUP and VLOOKUP).

LOOKUP is a function inherited from Lotus-123. There is a more powerful and less limited way in Excel. It is the INDEX/MATCH formulas. INDEX/MATCH can replace all lookup functions (VLOOKUP, HLOOKUP and LOOKUP) and offers many advantages.

Excel Functions and Formulas Sitemap

Go to the next lesson:
Lesson 18: HLOOKUP