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

Table Array

By

A Table Array used in Excel's LOOKUP Functions

A Table Array used in Excel's LOOKUP Functions

© Ted French
Definition:

A table array is one of the arguments used in Excel's lookup functions, such as VLOOKUP and HLOOKUP.

The LOOKUP functions search the table array to find specific information.

For VLOOKUP (vertical lookup), the table_array must contain at least two columns of data.

For HLOOKUP (horizontal lookup), the table_array must contain at least two rows of data.

Other arguments in the LOOKUP functions that make use of the table array:

lookup _value: located in the first column or row of the table_array.

index_num: The number of the column or row in the table_array that contains the data you are searching for.



Related Articles
Alternate Spellings: table_array

©2014 About.com. All rights reserved.