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.

Try:

=INDEX(A2:A12,MATCH(1,IF(G3>=B2:B12,IF(G3<=D2:D12,1)),0))

Or:

=INDEX(A2:A12,MATCH(1,(G3>=B2:B12)*(G3<=D2:D12),0))

Ctrl+Shift+Enter

So it was the merged cells! I knew it would be something simple!

Thank you for your help, I will mark this as solved.

Kind Regards,

Margate.

maybe this one:
(and try to not use merged cells)

You are welcome

If that takes care of your original question, & to say Thanks, please click on Add Reputtion (bottom left corner of the post of the person(s) who helped you)
then select Thread Tools from the menu (top right corner of your thread) and mark this thread as SOLVED.
If you did it already - ignore it.
Thank you.