+ Reply to Thread
Results 1 to 2 of 2

Timetable development with INDEX MATCH ROW formula using multiple criteria

  1. #1
    Registered User
    Join Date
    02-22-2013
    Location
    Lichfield, UK
    MS-Off Ver
    Excel 2003
    Posts
    12

    Timetable development with INDEX MATCH ROW formula using multiple criteria

    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
    Attached Images Attached Images
    Last edited by wyndland; 05-02-2013 at 02:10 PM. Reason: wrong Forum
    Win 7, Office 2010 but save as 2003 for others

  2. #2
    Registered User
    Join Date
    02-22-2013
    Location
    Lichfield, UK
    MS-Off Ver
    Excel 2003
    Posts
    12

    Re: Timetable development with INDEX MATCH ROW formula using multiple criteria

    Oops,

    forgot to mention the important bit probably.....

    I imagine I might want to find all the teaching going on at (say) Fibbersley Park on Wednesday morning by Nicola G Day

    Thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1