Thread: Selecting the i-th element from a range
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.worksheet.functions
Ron Rosenfeld
 
Posts: n/a
Default Selecting the i-th element from a range
On 16 Nov 2005 07:01:46 -0800, wrote:


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


=INDEX(...


--ron
Reply With QuoteReply With Quote