Excel functions and formulas           



Excel tips on functions and formulas

Excel Functions and Formulas contents

Excel functions worksheets

Excel and VBA Expert








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