Microsoft Office Tutorials and References

In Depth Information

**Using VLOOKUP with TRUE to Find a Value Based on a Range**

Figure 12.21.

Figure 12.21.
CHOOSE

CHOOSE is great for simple choices where the index number is

is great for simple choices where the index number is

between 1 and 254.

between 1 and 254.

Using

Using
VLOOKUP

to Find a Value Based on a Range

VLOOKUP stands for verticallookup. This function behaves differently,

depending on the fourth parameter. This section describes using VLOOKUP

where you need to choose a value based on a table that contains ranges.

Suppose that you have a list of students and their scores on a test. The

school grading scale is based on these ranges:

•
92
–
100 is an A.

•
85
–
91 is a B.

•
70
–
84 is a C.

•
65
–
69 is a D.

•
Below 65 is an F.

Follow these steps to set up a VLOOKUP for this scenario:

VLOOKUP
with

with
TRUE

TRUE
to Find a Value Based on a Range