View Single Post
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default 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