Hi,
I am preparing a spread sheet to present peripatetic teacher timetable options, where all data used throughout the workbook is stored on one sheet (part of which is attached)
My problem is straightforward in that, having researched the answers, it seems I need to use ROW() in my formula to return multiple entries based on certain MATCH criteria.
I have been using the following formula to retrieve single data sets:
=IF(ISNA(MATCH(1,('TT 2013-14'!$E$2:$E$399=$B$3)*('TT 2013-14'!$C$2:$C$399=$B31)*('TT 2013-14'!$D$2:$D$399="AM"),0)),"",INDEX('TT 2013-14'!$B$2:$B$399,MATCH(1,('TT 2013-14'!$E$2:$E$399=$B$3)*('TT 2013-14'!$C$2:$C$399=$B31)*('TT 2013-14'!$D$2:$D$399="AM"),0)))
Looking at the attachment, I imagine I might want to find all the teaching going on at (say) Fibbersley Park on Wednesday morning by Nicola G Day
I don't understand how to incorporate the ROW function to make the arrays read the next set of matching data.
Any help is going to be wonderful
Thanks
G
Bookmarks