Finding values considering multiple conditions

[jfrjfr]

Hi! I need a formula for this situation. I extracted a small fragment here and uploaded the excel :) Thank you!!!

There are Ids repeated according to other columns, so I need the STD value that considers the first 3 columns.

[#2]

@jfrjfr 

In E2 as an array formula confirmed with Ctrl+Shift+Enter:

=INDEX(M$2:M$1000,MATCH(1,($I$2:$I$1000=A2)*($J$2:$J$1000=B2)*($K$2:$K$1000=C2),0))

If your data have more than 1000 rows, adjust the number 1000 in the formula.

Fill down.

[#3]

@Hans Vogelaar Thank you! Unfortunately its not working. Did you try it and worked? It looks perfect, but it does not work in my case :\

[#4]

@jfrjfr 

Most probably formula was entered without CSE. I modified a bit what @Hans Vogelaar suggested to use as regular formula

=INDEX(M$2:M$1000,MATCH(1,INDEX(($I$2:$I$1000=A2)*($J$2:$J$1000=B2)*($K$2:$K$1000=C2),0),0))