![]() |
#1
|
|||
|
|||
![]()
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. |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
radicalrom | Excel | 7 | 01-06-2019 06:02 AM |
![]() |
Marcia | Excel | 4 | 10-26-2018 08:59 AM |
need Index, Match, Max to return SUMPRODUCT? | IRHSAM | Excel | 0 | 11-17-2017 09:48 AM |
Excel - Index and Match Function ,First Second and Third Match | paulzy95 | Excel | 10 | 09-29-2016 10:46 PM |
![]() |
danigirl121 | Excel | 7 | 06-08-2016 01:57 PM |