Excel Lookup Function - Array Form

There are two forms for the LOOKUP function in Excel - the Vector Form and the Array Form.

The difference between the two lies in where the function will look to retrieve data.

The vector form will only look in a single row or column while the array form will return data from the last row or column from a block of data called, not surprisingly, an array.

To find out more about using the array form of this function, read this tutorial on the Excel Lookup Function - Array Form.

• Lookup Formula with Multiple Criteria in Excel
• Excel Two Way Lookup Formula
• Find Multiple Fields of Data with VLOOKUP