Multiple Values bring up multiple results

[Burgers]

ok, so i have a huge Data table (DATA) in my excel workbook for my school.

I would use this formula to look up individual ID#'s and match them with their corresponding counselor : (counselor is in column 5 in DATA)

=VLOOKUP($A$2:$A$8729,DATA!$A$2:$E$56060,5,FALSE)

in the DATA table, ID#'s are listed multiple times (based on reporting term: fall10, spring 11, ect.) so i created this formula to return multiple values for 1 iD#:

=if(iserror(index(data!$A$2:$AB$65536,SMALL(IF(DATA!$a$2:$A$56000=$A$2,rOW(DATA!$A$2:$A$56000)),rOW(1:1)),8)),"",index(data!$A$2:$AB$65536,SMALL(IF(DATA!$a$2:$A$56000=$A$2,rOW(DATA!$A$2:$A$56000)),rOW(1:1)),8))

Now this formula works perfectly, but only if i enter in 1 ID# in cell A2. I want to be able to copy and paste a list ID#'s in A column and it return the multiple rows for each ID#.. is this possible?

Any help would be greatly appreciated!

 

[DonkeyOte]

For ref. x-posted: http://www.excelforum.com/excel-wor...ple-rows-but-want-to-use-multiple-values.html