Index based on more than 2 collumns

I would like to index n1 with formula based on column E wich represend the week based on column i,j and L, How can i bring it matching all this collumns?>
exercitiu.xlsx

Sorry but your explanation makes no sense (to me, at least). I dont understand where I, J and L (TBI OUTBOUBD and AHT) would be referenced to?

Walk me through how you would do this manually please.

Hmm maybe I do see.

I would add a helper column on sheet 2 (I used col P, use whatever you want, you could also hide it if needed)
P1=I1&J1&L1
copied down.

Then on sheet 1...
N1=INDEX(Sheet2!N:N,MATCH(Sheet1!I1&Sheet1!J1&Sheet1!L1,Sheet2!P:P,0))
copied down

Of course my result on n1 i intend to extract from sheet2 with dependency with collumns i mnentioned. E I J & L. Can we make it without the hellper? and i also need collumn e involved in this!

Can we make it without the hellper? and i also need collumn e involved in this!

Are you still using Excel 2016?

Unfortunately my company limited my office 365 just in one place so i need to go with lower versions on this example.

Try this:

=INDEX(Sheet2!$N$1:$N$10000,MATCH(1,(Sheet2!$E$1:$E$10000=E1)*(Sheet2!$I$1:$I$10000=I1)*(Sheet2!$J$1:$J$10000=J1)*(Sheet2!$L$1:$L$10000=L1),0))

**Array formulas are not entered in the same way as 'standard' formulas. Instead of pressing just ENTER, you first hold down CTRL and SHIFT, and only then press ENTER. If you've done it correctly, you'll notice Excel puts curly brackets {} around the formula (though do not attempt to manually insert these yourself).

Omg Yes i remembered! yesterday i could simply not see it. based on your previous help, the compound index, is made like this and it s array.

=IFERROR(INDEX(Sheet2!N:N,MATCH(1,(E2=Sheet2!E:E)*(KpiDataweek!I2=Sheet2!I:I)*(KpiDataweek!J2=Sheet2!J:J)*(L2=Sheet2!L:L),0)),"")

Thank you very much!

Yes, indeed - you have had help on this before!!!

See post #9.