Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 09-23-2021, 03:25 PM
Bosslb Bosslb is offline Index Match and return mutiple results from a table Windows 7 64bit Index Match and return mutiple results from a table Office 2019
Novice
Index Match and return mutiple results from a table
 
Join Date: Sep 2021
Posts: 1
Bosslb is on a distinguished road
Exclamation 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.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Index Match and return mutiple results from a table Index Results Help radicalrom Excel 7 01-06-2019 06:02 AM
Index Match and return mutiple results from a table 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
Index Match and return mutiple results from a table How to make MATCH/INDEX formula return multiple successive responses. danigirl121 Excel 7 06-08-2016 01:57 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:05 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft