Part II: Working with Formulas and Functions
For information about lookup formulas, see Chapter 14, “Using Formulas for Matching and Lookups.”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:E10:
=VLOOKUP(B1,{1,"One";2,"Two";3,"Three";4,"Four";5,"Five";6,"Six";7,"S
even";8,"Eight";9,"Nine";10,"Ten"},2,FALSE)