Forum Discussion
INDEX MATCH returning random data
Good Afternoon, I've been stuck on this for a while. I have two forms that collect data and I want to create an account overview with all the information. I've got all the student info connected and attendance records and that works okay but when I pull up a INDEX MATCH the name with fees paid. Individual rows show up fine for the first few students but then I get rows full of generic data. I hope the screen shots help. For example, 'Acosta' works and lists payments but not 'Exposito'.
This is the formula which resides AM4 for the first column of info:
=IFERROR(INDEX([AfterCareFees.xlsx]FeeForm!$I:$I,SMALL(IF(ISNUMBER(MATCH([AfterCareFees.xlsx]FeeForm!$F$2:$F$6351,$B$4,0)),MATCH(ROW([AfterCareFees.xlsx]FeeForm!$F$2:$F$6351),ROW($AM$1:$AM$44)),""),ROWS($A$1:A1))),"")
Any help would be greatly appreciated. Thank you.
This one lists generic dates and amounts, not the correct dates. And it is the same for all the students after 'Exposito'This is another workbook that collects data from a form.The correct information populates on this one and nothing with the formula has been changed. The correct information appears for the first 16 names and then it shows the generic dates on the rows.