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
Search JabSto ::




Custom Search