You got it ALMOST right...

Use this in the cell you want the first value
=INDEX($P$1:$S$2500,SMALL(IF($P$1:$P$2500=$A$3,ROW ($P$1:$P$2500)),ROW(1:1)),4)
and press CTRL-SHIFT-ENTER
then copy down

I changed $P$3 to $P$1 since you are counting the rows from 1....

Also changed ROW($1:$1) to ROW(1:1) since you want it to be ROW(2:2) in the
second row.

"John" wrote:

I am using the following formula and have tried numerous variations with no
luck.

=INDEX($P$3:$S$2500,SMALL(IF($P$3:$P$2500=$A3,ROW( $P$3:$P$2500)),ROW($1:$1)),4)

I am trying to find the value in Cell A3 and return results from the array
of column P through S. The value that is in Cell A3 will match a value in
column P. I want to return the result from column S.


Basically Cell A3 = TEST1, Cell P24, P25, P50 = Test1, and Cell S24, S25,
S50 = 94, 92, 88 (respectively)

When I use the above formula I should be able to return the first result
then modify the formula and return the second result and so on? I am not sure
what I am missing or if I am on the right track. Any ideas? Thanks