AREAS
function (ref)
Returns the number of classes of adjacent or single
cells of a reference.
Example:
=AREAS(A1) returns 1, and there is only one area.
LOOKUP
function (...)
This function searches for a value in a range of a
column, a row, or a matrix. You need to indicate the value to search for,
where you want to search for it, and where you want to obtain the result.
Example: In column
B we have a list of freinds' names, and in column
C their emails. In cell A1 we write the name of the
freind who's email we are searching for. In cell E1 we select the LOOKUP
function, and we insert the following parametres:
"search_value= A1", "comparation_vector=
B:B" and "result_vector = C:C". It will return to us the
email related to the person being searched.
HLOOKUP
function (lookup_value,table_array,row_index_num,range_lookup)
Searches the first row of the table or matrix of values,
and returns the result in the same column from a specific row.
Example: Lets imagine the
same situation as before with a column with names and another with the
emails, and we now want it to tell us who is two places below a freind
on the list, or the email that is found two rows below where we are currently
looking. We use the the HLOOKUP funcion with
the following parametres.
"searched for_value= A1" "search_matrix_in=
B:C" and "row_indicator=2" IT will return to us the email
of the relevant person situated two rows below the search.
VLOOKUP
function (lookup_value,table_array,col_index_num,range_lookup)
Search for a value in the first column to the left
and return the value in the same row from a specific column.
It has the same effect as the the previous function
except that this function carries out the search for columns.
MATCH
function (lookup_value,lookup_array,match_type)
Returns the relative position of an element, which
coincides with a value given in a specified order within a matrix.
match_type is the number
1, 0, or 1 and specifies how the value being searched for should coincide
with the values within the search_matrix.
If type_of coincidence is 1, COINCIDE will find the
highest value that is less than or equal to the searched for_value. The
values in the search_matrix need to be placed in ascending order: ...2,
1, 0, 1, 2; AZ: FALSE; TRUE.
If type_of coincidence is 0, COINCIDE will find the
first value that is exactly equal to the searched for_value. The values
in the search_matrix can be in any order.
If type_of coincidence is 1, COINCIDE will find the
smallest value that is greater than or equal to the value being searched
for. the search_matrix values need to be placed in descending order: TRUE;
FALSE; ZA; ...2; 1; 0; 1; 2; ... and so succesively.
If coincidence_type is omitted, it is presumed that
it is 1.
Example: =MATCH(23;{"grapes";,23\"pears";45\"apples";55})
returns 2, which is the position where the number 23 is found.
COLUMN
function (reference)
Returns the column number of a reference.
Example: COLUMN(D:H)
returns 4, because, the first column of the D:H matrix is the D
(column no. 4)
COLUMNS
function (matrix)
Returns the number of columns that a matrix is composed
of.
Example: =COLUMNS(A:C)
returns 3, because, the matrix has 3 columns.
