Quote:
Originally Posted by 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.
|
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