The discount schedule lookup table in the previous section is an example of a range lookup where you check to see if the lookup value falls within a range of values, such as 1–5 or 6–25. However, you often come across situations in which you need to match specific values instead of ranges.

For example, you might need to look up an employee ID, a part code, or a book’s ISBN number. These are examples of discrete value lookups where your formula needs to match some value exactly.

A tab le of customer names and account numbers is a good example of a lookup table that contains discrete lookup values. In this case, you want to use the VLOOKUP() function (or, less likely, the HLOOKUP() function) to find an exact match for a customer name you specify, and then return the corresponding account number. Figure 5.4 shows a simple data-entry screen that automatically adds a customer account number in column E after the user selects the customer name from a drop-down list in column D.

An example of a function that accomplishes this is in cell E3:
=VLOOKUP(D3, A2:B93, 2, FALSE)

The value in D3 is looked up in list of customer names in column A, and because the range_lookup argument is set to FALSE, VLOOKUP() searches for an exact match. If it finds one, it returns the corresponding account number from column B.

• Wallpaper Tips for Installation There are a lot of reasons to choose wallpaper over paint for the walls in your home. Wallpaper can add...
• Tips to Improve Your Serve There are a number of tips that you can employ in order to improve your tennis game. This week we...
• Tennis Glossary Lawn Tennis - This is the original name used to describe modern tennis, based primarily on the fact that it...
• Use this HSA Calculator to Predict the Future Value of Your Health Savings Account This post is for those of us of who are now or who will be covered under a high deductibe...
• 100 Quick Tennis Tips pt 3 Here are 100 quick and easy tennis tips to get your game going. We're going to spread this list out...