Hi

I can use match to find the first occurence of a value in a list - how can i
find the 2nd, 3rd, nth value in a list? I'm using excel 2007 btw.

Thanks

Max

Are you using VBA or formulas?

"Max Scott" wrote:

Hi

I can use match to find the first occurence of a value in a list - how can i
find the 2nd, 3rd, nth value in a list? I'm using excel 2007 btw.

Thanks

Max

Try this array formula, searching for the value 2

=IF(ISERROR(SMALL(IF($A$2:$A$20=2,ROW($A$2:$A$20), ""),ROW(A1))),"",SMALL(IF($A$2:$A$20=2,ROW($A$2:$A $20),""),ROW(A1)))

--
__________________________________
HTH

Bob

"Max Scott" wrote in message
...
Hi

I can use match to find the first occurence of a value in a list - how can
i find the 2nd, 3rd, nth value in a list? I'm using excel 2007 btw.

Thanks

Max

On Thu, 26 Feb 2009 11:03:43 -0000, "Max Scott" wrote:

Hi

I can use match to find the first occurence of a value in a list - how can i
find the 2nd, 3rd, nth value in a list? I'm using excel 2007 btw.

Thanks

Max


Take a look at the Arbitrary Lookups section on this page:

http://www.cpearson.com/excel/TablesAndLookups.aspx

--ron