#1
|
|||
|
|||
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. |
#2
|
||||
|
||||
It would be simpler for others to help you if you attach a sample sheet.
|
#3
|
||||
|
||||
Take a look at INDEX MATCH – multiple results
Technique is described there (O365 offers other tools AFAIK like the FILTER function) |
#4
|
|||
|
|||
It drives me mad! The worksheet almost certainly exists in front of them but people not add it!
|
#5
|
|||
|
|||
Quote:
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 |
#6
|
||||
|
||||
Quote:
If you follow the link I provided you will find that a simple CSE formula suffices It's not that complicated |
#7
|
|||
|
|||
I put that formula into the complex category and it can have an impact on performance
|
#8
|
||||
|
||||
Quote:
Complexity is in the eye of the beer holder |
|
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 |