Help with Index matching - formula worked last year but not now

Hi all,

I hope I'm posting this in the correct section.

I'm trying to use an index match to move over some pricing data...the formulas worked last year but for some reason this year they won't and nothing has changed to my knowledge.

the formula is:
=IF(INDEX(data1!$A$2:$K$10,MATCH(Sheet1!A2,Sheet2!$A$2:$A$10,0),SMALL(IFERROR(COLUMN($A$1:$I$1)/(LEFT(data1!$A$1:$K$1,3)="Qty"),100000),COUNTIFS(A$2:A2,A2)))=0,"",INDEX(data1!$A$2:$K$10,MATCH(Sheet1!A2,data1!$A$2:$A$10,0),SMALL(IFERROR(COLUMN($A$1:$K$1)/(LEFT(data1!$A$1:$K$1,3)="Qty"),100000),COUNTIFS(A$2:A2,A2))))

I've attached an example file so that you can see what I'm trying to do and how I would like it to look at in the end. There is also a 2nd formula, which I can post if needed, where in the 2nd part of this I'm trying to move pricing over as well if you can be so kind to help me with.

this was also posted at:
http://chandoo.org/forum/threads/hel...ditions.32849/
https://www.mrexcel.com/forum/excel-...ml#post4736895

thank you.