Results 1 to 3 of 3

Index Formula - adding a range condition

Threaded View

Henry c Index Formula - adding a... 04-29-2010, 10:14 AM
NBVC Re: Index Formular - adding a... 04-29-2010, 10:17 AM
Henry c Re: Index Formular - adding a... 04-29-2010, 10:19 AM
  1. #1
    Registered User
    Join Date
    11-11-2009
    Location
    Reading, England
    MS-Off Ver
    2010
    Posts
    69

    Index Formula - adding a range condition

    I have been working with the following formular

    =INDEX(Driver!$C$2:$C$200,MATCH(1,INDEX((Driver!$D$2:$D$200=F2)*(Driver!$N$2:$N$200=D2),0),0))

    However I wish to add an extra condition to it.

    I would like to add to these two conditions so that the time in column G must be between or equal to the times on sheet 'Driver' colums F and H (Note the time in F will always be earlier than H)

    Im not having much luck with this, any help would be really appreciated.

    Thanks in advance!
    Last edited by NBVC; 04-29-2010 at 10:53 AM.

Thread Information

Users Browsing this Thread

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

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