Lookup Function Excel Formula, An Excel Array Lookup allows you to lookup values in a table or array.