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 helpPlease Login or Register to view this content.
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.
Bookmarks