Find the results of multiple occurrences in lookup

[jmh2008]

I have a table where i want to combine columns from looking up items in the first column which has dups.,


Student # Home Phone Email Work
1 123-1245
1 me@com
2 456-4587
3 125-5698
3 452-5698


So I would like to see:
Student # Home Phone Email Work
1 123-1245 me@com
2 456-4587
3 452-5698 125-5698


No vba please!

Thanks,

 

[cbatrody]

Hi,

Try the following formula in E2:

=IFERROR(INDEX($B$1:$B$6,SMALL(IF($A$1:$A$6=$D2,ROW($A$1:$A$6)),COLUMN(A1))),"")

array entered (CTRL+SHIFT+ENTER)

drag the above formula to the columns on right (F2, G2 etc)

This is keeping in mind:

1. Student# is in column A (A2:A6)
2. Home Phone & Email in column B (B2:B6)
3. Student# is in column D

D2:1
D3:2
D4:3

 

[cbatrody]

PM me your e-mail address if you need the sample file that I created.!

 

[jmh2008]

I PM'd you with a sample workbook