14.6 Lookup functions
-
ADDRESS(
row,
column )
-
CHOOSE(
n,
list )
-
HLOOKUP(
lookup_key_value,
lookup_data,
row_index
{, lookup_type} )
-
LOOKUP(
lookup_key_value,
lookup_data,
result_data
{, all )
-
MATCH(
lookup_key_value,
lookup_data,
lookup_type )
-
VLOOKUP(
lookup_key_value,
lookup_data,
column_index
{, lookup_type} )