Spreadsheet Reference Functions: The important spreadsheet reference functions are
1. LOOKUP () functions: The LOOKUP function returns a value either from a one-row or one-column range or from an array. The lookup function has two syntax forms: Vector form and Array form.
The vector form of LOOUP looks in a one-row or one column range (known as a vector) for a value, and then returns a value from the same position in a second one-row or one column range. The array form of LOOKUP looks in the first row or column of an array for the specified value, and then returns a value from the same position in the last row or column of the array.
LOOKUP (Vector from) Syntax: = LOOKUP (search criterion, Search vector, Result vector) LOOKUP (Array form) Syntax: =(LOOKUP (lookup value, array)
2. VLOOK UP (): VLOOK UP is the vertical LOOKUP function. Use VLOOK UP to search the first column (columns are vertical) of a block of data and return the value from another column in the same row.
Syntax: = VLOOKUP (Search criterion; Array; Index; Sort Order)
3. HLOOKUP ( ): It is the Horizontal LOOKUP function, searches for a value in the first row of a table array and returns the corresponding value in the same column from another row of the same table array.
Syntax: HLOOKUP (search criteria; index; sorted)