Indexing with merged cells in the Array

[smls]

I am having a problem indexing from the "feed" ssheet to the "Fill in" sheet in the attached workbook. I am just trying to pulll the data from the feed sheet onto the other sheet by the employee name, in this case the highlighted cells.

In the actual workbook there are many more employees but I don't think that matters. There are going to be different feed sheets for each month so it shouldn't be all the complicated.

I was wondering if there was a problem becasue some of the cells in the index I was making are merged and centered as different sizes? I get the report on the feed sheet from a different department so I am trying to work with what I have at the moment. I'm hoping its just a silly over sight thats messing me up seeing as how all I've been doing for a couple weeks is staring at excel.

Thanks in advance for any help you can provide.


Sampleproblem indexing.xlsx

[micope21]

Hi

Try this
Cell C25 =IFERROR(INDEX('feed April'!$C$8:$O$39,MATCH(($A$2),'feed April'!$B$8:$B$39,0),MATCH((C4),'feed April'!$C$5:$O$5,0)),0) Then copy a cross

[smls]

Thanks, just what I needed

[TMS]

This will get the first few value, assuming you match up your headers:

=INDEX('feed April'!$B$8:$O$28,MATCH($A$2,'feed April'!$B$8:$B$28,0),MATCH(C$4,'feed April'!$B$5:$O$5,0)) and drag across.

However, I think you're going to be stuffed by the merged cells as you start match on row 5 (merged with 6) but then, when you get to "AAA", that's actually on row 6 (not merged). You could try using the formula referring to row 5 and, if there's an error, trying for row 6.

That would look like this:

=IFERROR(INDEX('feed April'!$B$8:$O$28,MATCH($A$2,'feed April'!$B$8:$B$28,0),MATCH(C$4,'feed April'!$B$5:$O$5,0)),INDEX('feed April'!$B$8:$O$28,MATCH($A$2,'feed April'!$B$8:$B$28,0),MATCH(C$4,'feed April'!$B$6:$O$6,0)))

And, to tidy the whole thing up:

=IFERROR(IFERROR(INDEX('feed April'!$B$8:$O$28,MATCH($A$2,'feed April'!$B$8:$B$28,0),MATCH(C$4,'feed April'!$B$5:$O$5,0)),INDEX('feed April'!$B$8:$O$28,MATCH($A$2,'feed April'!$B$8:$B$28,0),MATCH(C$4,'feed April'!$B$6:$O$6,0))),"")


Regards, TMS