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.

LOOKUP Function in Excel
Links to the Top of the Page

Excel Functions and Formulas Sitemap

Downloadable Tutorials, Examples and Templates