Funkcije tablične
Posljednja promjena 24.07.2005
| Lookup & Ref | ||||
| Name | Source | Type | Description | Syntax |
| ADDRESS | Built In | Lookup & Ref | Creates a cell address as text based on given row and column rumbers | =ADDRESS(Row_num,Column_num,Abs_num, A1,Sheet_text) |
| AREAS | Built In | Lookup & Ref | Returns the number of areas in a reference | =AREAS(reference) |
| CHOOSE | Built In | Lookup & Ref | Uses a specified index number to select one from up to 29 specified values | =CHOOSE(index_num,value1,value2,…) |
| COLUMN | Built In | Lookup & Ref | Returns the column number of the cell or a specified reference | =COLUMN(reference) |
| COLUMNS | Built In | Lookup & Ref | Returns the number of columns in an array or reference | =COLUMNS(array) |
| HLOOKUP | Built In | Lookup & Ref | Looks in the top row of a table or array and returns the value of the indicated cell | =HLOOKUP(lookup_value,table_array,row_index_num,range_lookup) |
| HYPERLINK | Built In | Lookup & Ref | Creates a shortcut that opens a document on your hard drive, a server or the internet | =HYPERLINK(link_location,friendly_name) |
| INDEX | Built In | Lookup & Ref | Alternative forms. Array form returns a value or array of values. Reference form returns a reference. | =INDEX(array,row_num,column_num) =INDEX(reference,row_num,column_num, area_num) |
| INDIRECT | Built In | Lookup & Ref | Returns a reference indicated by a value provided as text | =INDIRECT(ref_text,a1) |
| LOOKUP | Built In | Lookup & Ref | Alternative forms. Vector form looks up values in a one row or column range and returns a value in a second one row or column range. Array form looks in the first row or column of an array for the specified value and returns a value from the same position in the last row or column of the array | =LOOKUP(lookup_value,lookup_vector,
result_vector) =LOOKUP(lookup_value,array) |
| MATCH | Built In | Lookup & Ref | Returns the relative position of an item in an array that matches a specified value in a specified order | =MATCH(lookup_value,lookup_array, match_type) |
| OFFSET | Built In | Lookup & Ref | Returns a reference to a range that is a specified number of rows and columns from a cell or range of cells | =OFFSET(reference,rows,cols,height,width) |
| ROW | Built In | Lookup & Ref | Returns the row number of a reference | =ROW(reference) |
| ROWS | Built In | Lookup & Ref | Returns the number of rows in a reference | =ROWS(array) |
| RTD | Built In | Lookup & Ref | Retrieves real-time data from a program that supports COM automation | =RTD(ProgID,server,topic1,[topic2],…) |
| TRANSPOSE | Built In | Lookup & Ref | Returns the transpose of an array | =TRANSPOSE(array) |
| VLOOKUP | Built In | Lookup & Ref | Locates a specified value in the leftmost column of a specified table, and returns the value in the same row from a specified column in the table | =VLOOKUP(lookup_value,table_array,col_index_num,range_lookup) |