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

Excel Lookup Function - Vector Form

By May 12, 2014

Follow me on:

There are a number of lookup functions in Excel such as VLOOKUP and HLOOKUP but there is also a LOOKUP function.

This function is not as specialized as the other lookup functions so it can be used to find a single field of data located in either a column or row of a data table.

Further, this function has to forms - the Vector and Array forms.

The vector form lets you specify single rows or columns to search for the desired information, while the array form can be used to search large blocks of data.

To find out more about using the vector form of this function, read this tutorial on the Excel Lookup Function - Vector 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.