Ссылки и массивы functions
[ ] indicates optional parameters
АДРЕС(номер_строки, номер_столбца, [абсолютный_номер], [а1], [текст_листа])АДРЕС(номер_строки, номер_столбца, [абсолютный_номер], [а1], [текст_листа])
Returns a string containing the specified cell address.
| номер_строки | The row number of the cell. | ||||||||
| номер_столбца | The column number of the cell. | ||||||||
| абсолютный_номер | A number representing whether the row or column are to be absolute or relative. The possible values are: | ||||||||
| |||||||||
| If this parameter is omitted it defaults to 1. | |||||||||
| а1 | Specifies the style of the reference. The possible values are: | ||||||||
| |||||||||
| If this parameter is omitted it defaults to ИСТИНА. | |||||||||
| текст_листа | Optional sheet name with which to prefix the reference. |
ВПР(искомое_значение, табл_массив, номер_индекса_столбца, [диапазон_просмотра])
Returns a value from a vertical table, found by searching for the lookup value in the left column of the table and then returning a value from the same or a different column in the table.
| искомое_значение | The value to be found in the table. | ||||
| табл_массив | A reference containing the table cells. | ||||
| номер_индекса_столбца | The offset of the value to be returned, where 1 is the left column of the table. | ||||
| диапазон_просмотра | Whether to find an approximate or exact match. The possible values are: | ||||
| |||||
| If this parameter is omitted it defaults to ИСТИНА. |
ВЫБОР(номер_индекса, значение1, [значение2, ...])
Returns one of several values depending on the index.
| номер_индекса | The index of the value to be returned, should be in the range 1 to 29. |
| значение1, ... | Up to 29 values, one of which will be chosen to be the result. |
ГИПЕРССЫЛКА(адрес_документа, [имя])
Jumps to a cell or range when this cell is selected.
| адрес_документа | A text expression that evaluates to the form "filename" or "[filename]reference". |
| имя | The text to be displayed in the cell. If this parameter is omitted it defaults to the link location text. |
ГПР(искомое_значение, таблица, номер_строки, [диапазон_просмотра])
Returns a value from a horizontal table, found by searching for the lookup value in the top row of the table and then returning a value from the same or a different row in the table.
| искомое_значение | The value to be found in the table. | ||||
| таблица | A reference containing the table cells. | ||||
| номер_строки | The offset of the value to be returned, where 1 is the top row of the table. | ||||
| диапазон_просмотра | Whether to find an approximate or exact match. The possible values are: | ||||
| |||||
| If this parameter is omitted it defaults to ИСТИНА. |
Returns a reference from the specified text.
| ссылка | A text expression that evaluates to the name of a cell or range of cells. | ||||
| а1 | Specifies the style of the reference. The possible values are: | ||||
| |||||
| If this parameter is omitted it defaults to ИСТИНА. |
ИНДЕКС(ссылка, [номер_строки], [номер_столбца], [номер_области])
Returns a subset of an array or reference.
| ссылка | The array or reference of which you want the subset. |
| номер_строки | The number of the row to return. If this parameter is omitted all rows will be returned. |
| номер_столбца | The number of the column to return. If this parameter is omitted all columns will be returned. |
| номер_области | The number of the area to return when the reference contains more than one area. If this parameter is omitted it defaults to 1. |
Returns the number of areas contained in the reference.
| ссылка | The reference whose areas you want to count. |
ПОИСКПОЗ(искомое_значение, искомый_массив, [тип_сопоставления])
Returns a number representing the position of a value in a table.
| искомое_значение | The value to be found in the table. | ||||||
| искомый_массив | A reference containing the table cells. | ||||||
| тип_сопоставления | Whether to find an approximate or exact match. The possible values are: | ||||||
| |||||||
| If this parameter is omitted it defaults to 1. |
ПРОСМОТР(искомое_значение, вектор_просмотра, [вектор_результата])
Returns a value from a horizontal or vertical table, found by searching for the lookup value in the top row (for a horizontal table) or left column (for a vertical or square table) of the table and then returning a value from the corresponding position in the result range (if specified) or from the bottom row (for a horizontal table) or right column (for a vertical or square table) of the table.
| искомое_значение | The value to be found in the table. |
| вектор_просмотра | A reference containing the table cells. |
| вектор_результата | The range of cells from which to return a result. If this parameter is not specified the result will be returned from the opposite row or column of the table range. |
СМЕЩ(ссылка, строки, столбцы, [высота], [ширина])
Returns a new reference based on the specified reference.
| ссылка | The reference to be used as a starting point. |
| строки | The number of rows to move the reference up (negative) or down (positive). |
| столбцы | The number of columns to move the reference left (negative) or right (positive). |
| высота | The height of the new reference. If this parameter is omitted it defaults to the height of the old reference. |
| ширина | The width of the new reference. If this parameter is omitted it defaults to the width of the old reference. |
Returns the column number of the reference.
| ссылка | The reference whose column number you want. If this parameter is omitted it defaults to the cell containing the function. |
Returns the row number of the reference.
| ссылка | The reference whose row number you want. If this parameter is omitted it defaults to the cell containing the function. |
Returns the transposition of the specified array or reference.
| массив | The array or reference whose values you want to transpose. |
Returns the number of columns in the reference.
| массив | The reference whose columns you want to count. |
Returns the number of rows in the reference.
| массив | The reference whose rows you want to count. |