LOOKUP Function in Excel

The LOOKUP Function comes in two forms, the Vector form and the Array form.  The former is by far the most useful and distinctive.  Both forms search for an approximate match in an ordered range, and then return a value.  The Vector form uses one-dimensional ranges (one or two of them).  The Array form uses…