|
|
#1
09-23-2021, 03:25 PM
|
|||
|
|||
Index Match and return mutiple results from a table
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 Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Index Results Help
|
radicalrom | Excel | 7 | 01-06-2019 06:02 AM |
|
Index Match Formula to return value from a list with criteria
|
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 |
|
How to make MATCH/INDEX formula return multiple successive responses.
|
danigirl121 | Excel | 7 | 06-08-2016 01:57 PM |
Windows 7 64bit 
Office 2019
Threaded Mode