1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.
Ted French

Excel Lookup Function - Array Form

By May 14, 2014

Follow me on:

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.



Related Tutorials
Comments
No comments yet. Leave a Comment
Leave a Comment

Line and paragraph breaks are automatic. Some HTML allowed: <a href="" title="">, <b>, <i>, <strike>

©2014 About.com. All rights reserved.