Index Match Multiple criteia Giving zero value

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

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?

Edit: I have attached the file, as per the file I want to return the query only if the page=/123/ and country=USA. Please see the sheet1 for the work I did.

Have not looked at your file (yet), but that is an ARRAY formula, did you enter it using CTRL SHIFT ENTER?

What is wrong with the results you have?

Excel 2016 (Windows) 32 bit

	B	C
1	Page URL
2	/123/	homepage
3		number page
4		home number page

Sheet: Sheet1

Thanks for letting us know.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.