Excels INDEX with MATCH for multiple criteria

0 votes

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.

Nov 7 in Others by gaurav
• 22,040 points
31 views

1 answer to this question.

0 votes

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
answered Nov 8 by gaurav
• 22,040 points

Related Questions In Others

0 votes
1 answer

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

answered Feb 24 in Others by narikkadan
• 37,660 points
1,045 views
0 votes
1 answer

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

answered Oct 1 in Others by narikkadan
• 37,660 points
69 views
0 votes
1 answer

Excel Formula multiple Index Match and Average the result

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

answered Oct 31 in Others by narikkadan
• 37,660 points
50 views
0 votes
1 answer

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

answered Nov 17 in Others by narikkadan
• 37,660 points
17 views
0 votes
1 answer

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

Hello, yes u can find your birthdate using ...READ MORE

answered Feb 16 in Others by Edureka
• 13,640 points
137 views
0 votes
1 answer

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

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

answered Feb 16 in Others by Edureka
• 13,640 points
230 views
0 votes
0 answers

Convert Rows to Columns with values in Excel using custom format

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

Feb 17 in Others by Edureka
• 13,640 points
101 views
0 votes
1 answer

IF - ELSE IF - ELSE Structure in Excel

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

answered Feb 18 in Others by gaurav
• 22,040 points
68 views
0 votes
1 answer

Scan with filter returns zero results in DynamoDB

By accessing all items in a table ...READ MORE

answered Mar 4 in Others by gaurav
• 22,040 points
205 views
0 votes
1 answer

Pricing for aws ec2 instance volume

Currently, each Provisioned IOPS volume in Amazon ...READ MORE

answered Mar 4 in Others by gaurav
• 22,040 points
136 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP