Index Match 2 Criteria

Hi All,

Likely a simple answer but it's eluding me, I am trying to fill in columns F - I on the Summary tab given a date and a colour

The index match formula in column D works but I can't seem to add a second criteria on to look for colour, such as another section of the formula looking for "Yellow" in column A on the Detail tab

Thanks in advance!

Excel 2019 yes

Of course, I've completed the top three rows

You can use this formula in F4:

=SUMPRODUCT(Detail!$B$7:$NC$31,(Detail!$A$7:$A$31=F$3)*(Detail!$B$6:$NC$6=$B4))

then copy across and down as required.

Hope this helps.

Pete