Multiple columns and rows needs to be true

[mcnovy]

Hi,

I have finally givin' up, and will now resolve to mrexcel
First, I will point out that I am using Google Sheets, but let's imagine that excel and google sheets actually works the same way in my particular example.

I have a google forms, which asks me for the location for some items.
then it asks me for the items I have checked and that's it.
it saves the date and time in one column, the location in another column, and depending on the location the items checked in a third column.

I have a sheet, where I need to know if an item for a specific month have been checked or not.
and now for some graphics: (Examples of my sheet (I'm danish, and the document is danish, so I am using some words that gives more sense )

my form sheet
[TABLE="width: 500"]
[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Date time[/TD]
[TD]Location[/TD]
[TD]New York[/TD]
[TD]Washington[/TD]
[TD]Los Angeles[/TD]
[TD]Overwrite date[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]2016/02/03[/TD]
[TD]New York[/TD]
[TD]Empire; Library[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]2016/02/06[/TD]
[TD]Washington[/TD]
[TD][/TD]
[TD]Library; Park[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]2016/02/05[/TD]
[TD]New York[/TD]
[TD]MET[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]2016/03/05[/TD]
[TD]New York[/TD]
[TD]Library; Park[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[/TABLE]


My overview sheet
[TABLE="width: 500"]
[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD]year[/TD]
[TD]2016[/TD]
[TD]month[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD]MET[/TD]
[TD]Library[/TD]
[TD]Empire[/TD]
[TD]Park[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]New York[/TD]
[TD]X[/TD]
[TD]X[/TD]
[TD]X[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Washington[/TD]
[TD][/TD]
[TD]X[/TD]
[TD][/TD]
[TD]X[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Los Angeles[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[/TABLE]

Well.. I can't seem to get it working, here is what I have tried so far:
Cell D3 in overview sheet
=ArrayFormula(IF(isnumber(search(D$3;INDEX('Answers 1'!$C:$C;MATCH($E$1;IF(ISBLANK('Answers 1'!$F:$F);MONTH(datevalue('Answers 1'!$A:$A));month(datevalue('Answers 1'!$F:$F))));0)));"X";""))
Replace ArrayFormula with {}
I know I don't search for the correct year, I am just trying to get it to work for now.

I hope it is understandable what I am trying to archive, and hopefully someone better at excel than I can help me out.
Thanks