O'Reilly logo

Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours by Trudi Reisner

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

How to Use Lookup Functions

Lookup functions search for values within tables or lists. Each lookup function uses a different method for searching and returning values. Each method is suited for a particular task. Anytime your worksheet uses tables to hold values, such as tax tables or price tables, you can employ a lookup function for added power in the application.

VLOOKUP and HLOOKUP

These two lookup functions search for values in tables based on a lookup value, the value you are trying to match. For example, a tax table contains tax rates based on income. Income is the lookup value. VLOOKUP searches vertically in a column of values and then returns a corresponding value from the table. HLOOKUP searches horizontally in a row of values and then ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required