Index Match Multiple criteia Giving zero value

[lauren11]

<code>=INDEX('Search Console Data'!$D$2:$D$76140,SMALL(IF(ISNUMBER(MATCH('Search Console Data'!$C$2:$C$76140,Sheet1!$B$2,0)),MATCH(ROW('Search Console Data'!$C$2:$C$76140),ROW('Search Console Data'!$C$2:$C$76140)),""),ROWS($A$2:A2)))</code>

The above code is for single criteria works awesome but the problem is multiple criteria, from the above code I am getting the values that matched with the cell value "Sheet1!$B$2" but along with that I need to match the other value in different sheet 'Search Console Data'!$b$1:$b$100="USA". How can I apply multiple criteria in the above formulae. Thanks for the help

With my knowledge I tried this (Sheet1!$B$2)*( 'Search Console Data'!$b$1:$b$100="USA") but it seems not working. Any idea?

I have attached the file, as per the file I want to return only if the page=/123/ and country=USA. Please see the sheet1 for the work I did. In the attached file I created single criteria formulae how can I update the formulae to multiple criteria

https://docs.google.com/spreadsheets/d/1SVLOVxg23umsioSWUmzacpT8yzu1g3XVPuCn5sFnp8Q/edit?usp=sharing

 

[James006]

Hello,

Do you mean that within your Sheet1 ...

1. you are about to insert a new column (say in Column A ) ... to show the country ...

2. you need your current formula to be amended to include the country as an additional criteria

 

[Saba Sabaratnam]

As James asked, I am not sure if you want to keep your formula and update for multiple criteria. However, I used another formula to apply multiple criteria.

Enter the formula as array formula using Shift + Cont + Enter. You can include more criteria in ($C$2:$C$8=Sheet1!$B$2)*($B$2:$B$8="USA") part of the formula by using *. Note that I hard coded "USA".


=INDEX($D$2:$D$8,SMALL(IF((($C$2:$C$8=Sheet1!$B$2)*($B$2:$B$8="USA")),ROW('Search Console Data'!$2:$8),""),ROW('Search Console Data'!D1)))

Kind regards

Saba