I think I found a work around for the previous question I am now using the
formula below which changes the referenced cell as I autofill down. However I
am getting #NUM! on some cells where there is no data found. I thought I put
no errors in the formula. Anyhelp?


=IF(ISERROR(INDEX($P$1:$S$2500,SMALL(IF($P$1:$P$25 00=$A3,ROW($P$1:$P$2500)),ROW($1:$1)),4)),"",(INDE X($P$1:$S$2500,SMALL(IF($P$1:$P$2500=$A3,ROW($P$1: $P$2500)),ROW($5:$5)),4)))