O'Reilly logo

Master VISUALLY® Excel® 2010 by Elaine Marmel

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

Chapter 13. Working with Commonly Used 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 you have stored daily rainfall values in your worksheet for each day of the year. You can set up a VLOOKUP function to quickly ...

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