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