The "INDEX" function in Excel: description, application and examples

Currently, Excel is second only to Word in popularity. It allows you to easily carry out a wide variety of economic and statistical calculations on a large amount of data. For this purpose, it provides a large number of built-in functions, including auxiliary ones. Some of them are able to carry out actions, including on data arrays. The "INDEX" function also belongs to them. In Excel, it is used both separately and with SEARCH, which will be described below.

Description

The "INDEX" function in Excel returns the value (a reference to the value) of the contents of the cell specified by the row and column numbers of the table or the named range.

Its syntax is simple and looks as follows: INDEX (array, row number, column number).

. . , , .

"" Excel «#!». , , , .

"" .

, , 4 4 (. ). 1:5 «= (2:5, 2, 3)» ( ) «», «».

, 2 «», : (2:5, 1).

"" Excel

, , . , "" Excel , . , . .

, .

3:6.

, D1. , , «». (1), , «= (D1;3:6;0)» (. ). 3. 3:6 «».

0 , D1.

,

, , "" ( , . . ). , . . «Ctrl+Shift+Enter». .

"" "" Excel:

, . . , . , , H2 , «».

. , H2, , . , , «=(2:5;1;2)». , . - . , , "", . , «», G2 «. 2» H2. , , , , 0.

1 (2:5;1;2) : (G2;A2:A5;0), 2 — (H2; 2:2;0).

: (2:E5; (G2;A2:A5;0); (H2; 2:2;0)). , «», «10».

, "" Excel «» . , , 4 H2:J3. , , , «» , .

, 2:5 . , . $$2:$$5. , . . ($G$2;$A$2:$A$5;0) ($H$2; $2:$2;0).

: ($$2:$$5; ($G$2;$$2:$5;0); ($H$2; $$2:$$2;0)).

,

, , . .

Now you know how to use the INDEX function in Excel. Examples of its joint use with “SEARCH” are also known to you, and you can correctly apply them to solve many practical problems.