INDEX and MATCH returns #NA

[paras7]

Hi,
I have monthly planner data in a spreadsheet with fields as date(one date repeats 3 times to display 3 eight hrs shifts/day separately), shift(a/b/c) and schedule for 8 sections(S1 to S8).
I wish to have a formula where I can supply date and shift so that I can get the schedule for the corresponding date/shift for any particular section.

I've been using INDEX & MATCH for this purpose but for some reason its not giving the result that I'm looking for. I've tried to input array formula by ctrl+shift+enter.

my formula looks like

{=INDEX($A$1:$J$181,MATCH(1,($A$1:$J$181=$L$1)*($B$1:$J$181=$M$1),0),7)}

Here I tried to have Today's A-shift schedule for Section-5 i.e the 7th column(column G).
Please correct me.

Regards

 

[Aladin Akyurek]

MATCH should be applied to vectors (1d ranges), not matrices.

Note. A scaled-down sample can be posted here using one of the methods listed in the following: Attachments or using this add-in:https://app.box.com/s/soezox25h3w0q5s4rcyl instead of an image or link to the outside.