Selecting the i-th element from a range
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
|