Microsoft Office Tutorials and References
In Depth Information
Figure 14-18: You can replace the lookup table in D1:E10 with an array constant.
You can use a two-dimensional array in place of the lookup range. The following formula returns the same res-
ult as the previous formula, but it does not require the lookup range in D1:E10:
=VLOOKUP(B1,{1,”One”;2,”Two”;3,”Three”;4,”Four”;5,”Five”;
6,”Six”;7,”Seven”;8,”Eight”;9,”Nine”;10,”Ten”},2,FALSE)
This chapter introduced arrays. Chapter 15 explores the topic further and provides many additional examples.
Search JabSto ::




Custom Search