+ Reply to Thread
Results 1 to 8 of 8

Index Match Multiple criteia Giving zero value

  1. #1
    Registered User
    Join Date
    07-03-2019
    Location
    USA
    MS-Off Ver
    2013
    Posts
    4

    Index Match Multiple criteia Giving zero value

    Please Login or Register  to view this content.
    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.
    Attached Files Attached Files
    Last edited by lauren11; 07-03-2019 at 03:23 AM. Reason: File Attachment

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Index Match Multiple criteia Giving zero value

    Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

  3. #3
    Registered User
    Join Date
    07-03-2019
    Location
    USA
    MS-Off Ver
    2013
    Posts
    4

    Re: Index Match Multiple criteia Giving zero value

    No one? I need this badly

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Index Match Multiple criteia Giving zero value

    Have not looked at your file (yet), but that is an ARRAY formula, did you enter it using CTRL SHIFT ENTER?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,339

    Re: Index Match Multiple criteia Giving zero value

    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
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  6. #6
    Registered User
    Join Date
    07-03-2019
    Location
    USA
    MS-Off Ver
    2013
    Posts
    4

    Re: Index Match Multiple criteia Giving zero value

    In the attached excel file I am using single criteria I would like to use multiple criteria.I would like to return results only when country is "USA" and page is "/123/". I am new to excel formulaes I dont understand how can make the formulae with multiple criteria. Thanks for your help.

  7. #7
    Registered User
    Join Date
    07-03-2019
    Location
    USA
    MS-Off Ver
    2013
    Posts
    4

    Re: Index Match Multiple criteia Giving zero value

    It seems I made it.
    Please Login or Register  to view this content.

  8. #8
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,339

    Re: Index Match Multiple criteia Giving zero value

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Index Match across two sheets giving unexpected results
    By Sprong in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-30-2019, 04:02 PM
  2. Index/match - giving #NA but value is correct
    By MartinGTC in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 12-12-2017, 12:49 PM
  3. [SOLVED] Index - Match formula not giving me an expected result
    By longbow007 in forum Excel General
    Replies: 5
    Last Post: 11-25-2015, 07:34 PM
  4. INDEX/MATCH with =LARGE is giving duplicates
    By keith740 in forum Excel General
    Replies: 6
    Last Post: 10-07-2015, 03:35 AM
  5. [SOLVED] Rank countif with index match is not giving top results
    By amartin575 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-01-2014, 10:17 PM
  6. [SOLVED] Index, Match and Indirect giving REF error
    By stanleds in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-15-2013, 06:08 AM
  7. [SOLVED] Three questions starting with Index, Match giving #REF! error
    By JO505 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-02-2013, 07:42 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1