I am currently using the following formula to find all the row numbers in a one-dimensional range called "StudentList" that match a value stored in C3. I'm using this data to retrieve all of the matching records.
=if(iserror(ArrayFormula(SMALL(IF(StudentList=$C$3,ROW(StudentList)),ROW(1:1)))),"",ArrayFormula(SMALL(IF(StudentList=$C$3,ROW(StudentList)),ROW(1:1))))
I now have need to only return those rows where the corresponding row in a related range called "InteractionList" also match the value stored in C4.
I have tried placing an OR statement around "StudentList=$C$3" and include something like "InteractionList=$C$4", but it doesn't work. I don't think the formula is tracing through the two ranges simultaneously.
Any suggestions?
Bookmarks