#### Overview of this book

Excel is a popular program. Millions of people throughout the world use it on a regular basis. But it’s a safe bet that the vast majority of users have yet to discover some of the amazing things this product can do. 101 Excel 2013 Tips, Tricks, & Timesavers?is packed with information that you need to know in order to confidently and seamlessly master the challenges that come with using Excel! Excel 2013 is excellent, but there's lots to learn to truly excel at Excel! In this latest addition to his popular Mr. Spreadsheet's Bookshelf series, John Walkenbach, aka "Mr. Spreadsheet," shares new and exciting ways to accomplish and master all of your spreadsheet tasks. From taming the Ribbon bar to testing and tables, creating custom functions, and overcoming "impossible" charts, mixing nesting limits, and more,?101 Excel 2013 Tips, Tricks, & Timesavers?will save you time and help you avoid common spreadsheet stumbling blocks.

Tip 34: Looking Up an Exact Value

The VLOOKUP and HLOOKUP functions are useful if you need to return a value from a table (in a range) by looking up another value.

The classic example of a lookup formula involves an income tax rate schedule (see Figure 34-1). The tax rate schedule shows the income tax rates for various income levels. The following formula (in cell B3) returns the tax rate for the income value in cell B2:

`=VLOOKUP(B2,D2:F7,3)`

Figure 34-1: Using VLOOKUP to look up a tax rate.

The tax table example demonstrates that VLOOKUP and HLOOKUP don’t require an exact match between the value to be looked up and the values in the lookup table. In some cases, though, you might require a perfect match. For example, when looking up an employee number, close doesn’t count. You require an exact match for the number.

To look up only an exact value, use the VLOOKUP (or HLOOKUP) function with the optional fourth argument set to FALSE.

Figure...