I need to return mulitple results in several columns please help

J

Jerry

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top