+ Reply to Thread
Results 1 to 1 of 1

Incorporating ROW into INDEX MATCH

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

    Incorporating ROW into INDEX MATCH

    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
    Attached Images Attached Images
    Win 7, Office 2010 but save as 2003 for others

+ 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