Lookup functions
Vlookup (Searches the first column of a table/array Lookup value: The value to search for.
for the lookup value and return its related data from
Table array: The table of data to search for the value
a specified column).
in. It looks for the value in the leftmost column.
=vlookup(lookup_value,table_array,col_index_num,
Col index num: The column number from the left of
[range_lookup])
the data to be returned.
Range_lookup: Logical value that could be true or
false(0,1)
1 is used when searching into range of numbers
Lookup value: The value to search for.
Hlookup (Searches the first row of a table/array for Table array : The list of data to search for the value
the lookup value and return its related data from a in. It looks for the value in the leftmost column.
specified row)
row index num: The row number from the left of the
data to be returned.
=Hlookup(lookup_value,table_array,row_index_nu range_lookup: Logical value that could be true or
m,[range_lookup]) false.
The Excel INDEX function returns the value at a =INDEX (array, row_num, [col_num], [area_num])
given position in a range or array. You can use
index to retrieve individual values or entire rows
and columns.
A number representing a position in lookup_array. lookup_value - The value to match in lookup_array.
MATCH (lookup_value, lookup_array, lookup_array - A range of cells or an array reference.
[match_type])
match_type - [optional] 1 = exact or next smallest
MATCH returns a position. To retrieve a value. (default), 0 = exact match, -1 = exact or next largest.
How to use INDEX and MATCH two formulas can look up and return the value of a
cell in a table based on vertical and horizontal criteria
