# Finding values considering multiple conditions

Occasional Contributor

# Finding values considering multiple conditions

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.

3 Replies

# Re: Finding values considering multiple conditions

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.

# Re: Finding values considering multiple conditions

@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

# Re: Finding values considering multiple conditions

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