Index Match and return mutiple results from a table

[bosslb]

Hello,

I am currently using this formula to return data from one table that has a "Student ID" column.

Sometimes the Student ID is repeated in the table and so I want to return all the rows that has the same Student ID in that table.

With this formula, I am getting just the 1st row!



=IF(INDEX(All_Appended[#Data], MATCH($O$3,All_Appended[Student ID],0), MATCH(D6,All_Appended[#Headers],0))=0, "-",INDEX(All_Appended[#Data],MATCH($O$3,All_Appended[Student ID],0), MATCH(D6,All_Appended[#Headers],0)))





Anyone can help please to make this work?

Thank you.

 

[maabadi]

Welcome to MrExcel Message Board.
Please upload example data with Description below of my post.
Or try this:

Book1
	A	B	C	D	E	F	G
1	Student ID	Data			Student ID	Data
2	12484	Data1			12484	Data1
3	14567	Data2				Data5
4	15786	Data3				Data9
5	13254	Data4
6	12484	Data5
7	14567	Data6
8	15786	Data7
9	13254	Data8
10	12484	Data9
11	14567	Data10
12	15786	Data11
13	13254	Data12
14
Sheet1

Cell Formulas
Range	Formula
F2:F5	F2	=IFERROR(INDEX(All_Appended[Data],AGGREGATE(15,6,(ROW(All_Appended[Data])-ROW($B$2)+1)/(All_Appended[Student ID]=$E$2),ROWS($E$1:E1))),"")