Returns the number of classes of adjacent or single cells of a reference.
Example: =AREAS(A1) returns 1, and there is only one area.
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 e-mails. In cell A1 we write the name of the freind who's e-mail 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 e-mail 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 e-mails, and we now want it to tell us who is two places below a freind on the list, or the e-mail 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 e-mail 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; A-Z: 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; Z-A; ...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.
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)
Returns the number of columns that a matrix is composed of.
Example: =COLUMNS(A:C) returns 3, because, the matrix has 3 columns.
