Cell Function stops at row 29 should work in 11000 rows

[CityMPLSEmpolyee]

I have built a worksheet that has 12 columns of data & 11000 rows at row 29 the functions stop giving there looked up value.
the function that is being used is as follows
[=IF($D29="","",IFERROR(INDEX('Imported Data'!$E$3:$E$11006,MATCH($D29&L$4,'Imported Data'!$C$3:$C$11006&'Imported Data'!$D$3:$D$11006,0),1),0))]
this function only changes the column leters H thru N ($D29&L$4) L is the veriable
when I look at my data that is looked up I should get 1.70 and I get 0.00, there should not be an error I tested the function and I get values were ther is a value and N/A where theres not a value.
I am runing this function 7 columns and 11000 rows, and it stops at row 29. there are also 16 other worksheets and 10 of them have the same problem.

[FDibbins]

1. that is an ARRAY formula and needs to be entered using CTRL SHIFT ENTER, not just enter
2. Using an ARRAY formula over that large range may slow your file down, perhaps try this regular formula instead?
=IF($D29="","",IFERROR(INDEX('Imported Data'!$E$3:$E$11006,MATCH($D29&L$4,INDEX('Imported Data'!$C$3:$C$11006&'Imported Data'!$D$3:$D$11006,0),0))),1,0)
3. What is IN D29 etc?

[CityMPLSEmpolyee]

Column D is an Identifier that is used to find the corecte data in a worksheet that I dump a CSV Text file in to.

note
I will follow up on your post on monday after I try out your suggestion.
thanks

[CityMPLSEmpolyee]

Thanks for your help.
it turns out that in the file I was using I needed to do a copy drag for the cells to get them activated.
They looked right but not activated.
I don't know how else to explain it.

I did try your formula but got errores (#N/A)