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.

It would be simpler for others to help you if you attach a sample sheet.

Take a look at INDEX MATCH – multiple results
Technique is described there


(O365 offers other tools AFAIK like the FILTER function)

It drives me mad! The worksheet almost certainly exists in front of them but people not add it!

That is exsactly what index and match do (and vlookup) it finds the first one.

if you want it to find all it will be a lot more work, but sometimes a Pivot table might be a quick win.

As Marcia said always add a work sheet example

If you follow the link I provided you will find that a simple CSE formula suffices
It's not that complicated

I put that formula into the complex category and it can have an impact on performance

Complexity is in the eye of the beer holder