Index match array not working

[PHIL.Pearce84]

{=INDEX(Sheet1!D:D,MATCH(1,('Original Chart'!$I$3=Sheet1!B:B)*($J$3=Sheet1!A:A)*($K$3=Sheet1!E:E)*(E30=Sheet1!G:G),0))}

Hi I have the above formula which seems to work in the first cell but not in any others?? Can anyone help? Column E is not fixed as there is a different time on each row.

 

[Aladin Akyurek]

What result do you get, #N/A?

By the way, it's better not to refer to whole columns in this type of formulas for reasons of efficiency...

 

[PHIL.Pearce84]

That's right, not sure if I need some form of IfERROR in there?

Ah ok thanks for the pointer........it sped it up quite a lot!

 

[Aladin Akyurek]

What result do you get, #N/A?

By the way, it's better not to refer to whole columns in this type of formulas for reasons of efficiency...

Put the INDEX put in an IFNA or IFERROR call...

{=IFNA(INDEX(...),"")}