Index Match Array

Hi, I have an index match array that only works for one column of data, is there a way to get it to work with out changing my current set up i.e merged cells.

I have highlighted in Red the ones that don't work and in yellow the drop down.

Many Thanks

Luke