Chapter 14. Working with Lookup Formulas
Look up a Single Value in a Column
You can use the VLOOKUP function to find a value in one column of a range of related values. In the range, information on any given row provides all the information about that row.
The VLOOKUP function vertically searches the leftmost column of the range to find a value you specify. When the VLOOKUP function finds the value in the leftmost column, it searches across the row for one of the values in that row; you use one of the VLOOKUP function's arguments to identify the column containing the value you want to find. For example, suppose that you have stored daily rainfall values in your worksheet for each day of the year. You can set up a VLOOKUP function to quickly search ...
Get Master Visually®: Excel® 2007 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.
