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:
This chapter introduced arrays. Chapter 15 explores the topic further and provides many additional examples.
Search JabSto ::

Custom Search