I am experimenting with excel's functions. Say I have the following example values
Column
A1 - "Andrew"
B1 - "Morton"
B2 - "Andrew"
A2 - "Morton"
A3 - "2"

Why is my formula not printing the output 2?

```=INDEX(\$A\$3:\$A\$3,
MATCH(A1, (\$A\$1=\$B\$2:\$B\$2) * (\$B\$1 = \$A\$2:\$A\$2), 0))
```

The following prints the correct output 2 with single criteria.

```=INDEX(\$A\$3:\$A\$3,
MATCH(A1,\$B\$2:\$B\$2,0),1)
```

Nov 7, 2022 in Others 451 views

## 1 answer to this question.

How to Use INDEX MATCH With Multiple Criteria in Excel

• Step 1: Insert a normal INDEX MATCH formula.
• Step 2: Change the MATCH lookup value to 1.
• Step 3: Write the criteria
• 23,220 points

## How to use next-seo for setting nextjs meta tag with multiple OGP images?

https://github.com/garmeeh/next-seo use this git repo that contains ...READ MORE

## Is there a way to SUMIFS with multiple criteria + true or false?

You can add this as the  last criteria: =SUMIFS(STORE!\$C\$6:\$C\$1000;STORE!\$A\$6:\$A\$1000;""&SUMMARY!\$D\$5&"";STORE!\$D\$6:\$D\$1000;""&SUMMARY!\$C\$9&"";STORE!\$E\$6:\$E\$1000;""&SUMMARY!D8&"";STORE!\$AA\$6:\$AA\$1000;TRUE) STORE!\$AA\$6:\$AA\$1000: ...READ MORE

## Excel Formula multiple Index Match and Average the result

If the conditions are separate and unrelated, ...READ MORE

## Excel - IF combined with Index Match

Try: =IFERROR(IF(ISNUMBER(O2),VLOOKUP(A2,Sheet2!\$C\$2:\$E\$10,3,FALSE),""),"") =IFERROR(IF(ISNUMBER(O2),INDEX(Sheet2!\$E\$2:\$E\$10,MATCH(A2,Sheet2!\$C\$2:\$C\$10,0)),""),"") where the first "" means that O2 is not a number, ...READ MORE

## Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

## Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

## IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE