Results 1 to 6 of 6

Index Match not matching

Threaded View

Margate Index Match not matching 02-21-2018, 08:22 AM
Phuocam Re: Index Match not matching 02-21-2018, 08:26 AM
Margate Re: Index Match not matching 02-21-2018, 08:29 AM
sandy666 Re: Index Match not matching 02-21-2018, 08:27 AM
sandy666 Re: Index Match not matching 02-21-2018, 08:30 AM
Norie Re: Index Match not matching 02-21-2018, 08:31 AM
  1. #1
    Forum Contributor
    Join Date
    01-18-2013
    Location
    England
    MS-Off Ver
    2016 (Mac)
    Posts
    149

    Index Match not matching

    Hello everyone,

    I am trying to create a simple index match but for some reason all i get it a #N/A result? I'm sure it's something simple that I have overlooked but cannot seem to work it out

    I just need to index column A (A2:A12) and then find a match between the two dates that are along that row. Once a match is found then the data should return in my case ST.


    Below is a screen shot of my data:
    Screen Shot 2018-02-21 at 12.18.27.jpg

    And here is my code (array formula):

    =INDEX(A2:A12,MATCH(1,IF(G3>=B2:C12,IF(G3<=D2:E12,1)),0))
    I have also attached the spreadsheet.
    The cells are merged but this is practical for my spreadsheet. I don't think that this will effect the problem though.

    Thank you in advance for any help.
    Attached Images Attached Images
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Index Match matching two criteria
    By rish3005 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-09-2017, 01:55 PM
  2. [SOLVED] Matching specific characters in a row using INDEX/MATCH
    By Phalanxz in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-13-2016, 03:42 PM
  3. [SOLVED] Index and Match to return ALL matching values
    By garciapliz in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-07-2015, 05:41 AM
  4. [SOLVED] Index/Match and return all matching values
    By OLLY-7 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-04-2014, 06:09 PM
  5. Replies: 13
    Last Post: 12-13-2012, 11:44 AM
  6. Using INDEX and MATCH to find the 2nd matching value?
    By mysterydave in forum Excel General
    Replies: 4
    Last Post: 01-22-2009, 10:23 AM
  7. Index and Match-find the the matching number
    By windme in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-10-2008, 03:09 PM

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