Selecting the i-th element from a range

[kakofoniks]

Seems like this should be straightforward but I just don't know how.
Given the following setup:


A B C D E
----------------------------------------------
1 | -2 0 -3 -1


is there a formula that lets me choose the 2nd element from *range*
A11? I am using MATCH() to get the position I am interested in.

Thanks!
K

 

[Ron Rosenfeld]

Seems like this should be straightforward but I just don't know how.
Given the following setup:


A B C D E
----------------------------------------------
1 | -2 0 -3 -1


is there a formula that lets me choose the 2nd element from *range*
A11? I am using MATCH() to get the position I am interested in.

Thanks!
K

=INDEX(...


--ron

 

[kakofoniks]

Looking at answers to earlier questions, just realised the answer to
this one is:

=INDEX(A11,2)

which would return the second item from this list. The second argument
is typically the result of a MATCH() operation.