LOOKUP

Excel functions                              Microsoft Excel Examples

 

 

Excel tips on functions and formulas

Excel Functions and Formulas

Excel examples

Excel and VBA Expert

Excel fonctions et formules

Special

Excel Functions

2003-2010

 

sumproduct

index-match

subtotal

iserror

countif

sumif

hlookup

lookup

vlookup

 

 

Special

Excel Functions

2007-2010

 

averageif

averageifs

countifs

sumifs

iferror

 

 

 

 

 

 

 

Excel Functions and Formulas

 

Excel Macros and VBA

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

 

 

 

Excel tips on functions and formulas

Excel Functions and Formulas

Excel examples

Excel and VBA Expert

Excel fonctions et formules

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