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