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 ...
Get Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
