Finding values considering multiple conditions

Occasional Contributor

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.

 

jfrjfr_0-1610975313549.png

3 Replies

@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.

@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

@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))