How to look up a value in a list and return multiple corresponding values in
each column. I can get the first column to work with this array:

=IF(ISERROR(INDEX($N$1:$O$411,SMALL(IF($N$1:$N$411 =$N$415,ROW($N$1:$N$411)),ROW(1:1)),2)),"",INDEX($ N$1:$O$411,SMALL(IF($N$1:$N$411=$N$415,ROW($N$1:$N $411)),ROW(1:1)),2))

but when I apply it to the other columns it will not work.

Ashish 234 5 76
Sanjay 334 6 45
Pongal 434 7 34
Ashish 534 8 56
Rajesh 634 9 86
Suresh 734 10 45
Ashish 834 11 12

Results
Ashish 234 5 76
534 8 56
834 11 12

--
JW