Excels INDEX with MATCH for multiple criteria

Question

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)

Thanks in advance.

Answer 1

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