Selecting the i-th element from a range

K

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*
A1:D1? I am using MATCH() to get the position I am interested in.

Thanks!
K
 
R

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*
A1:D1? I am using MATCH() to get the position I am interested in.

Thanks!
K
Click to expand...


=INDEX(...


--ron
 
K

kakofoniks

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

=INDEX(A1:D1,2)

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