J
John
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
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