Chapter 16: Introducing Array Formulas
377
You can use a two-dimensional array in place of the lookup range. The following formula returns
the same result as the previous formula, but it does not require the lookup range in D1:E1:
=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 17 explores the topic further and provides some addi-
tional examples.