LOOKUP

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

 

 

 

         

SUMPRODUCT    INDEX/MATCH    SUBTOTAL    ISERROR    HLOOKUP    LOOKUP    VLOOKUP
AVERAGEIF    AVERAGEIFS   COUNTIF    COUNTIFS    SUMIF    SUMIFS    IFERROR