+ Reply to Thread
Results 1 to 3 of 3

Index / Match Question

Hybrid View

  1. #1
    Registered User
    Join Date
    10-30-2017
    Location
    United States
    MS-Off Ver
    2016
    Posts
    20

    Index / Match Question

    I have an index/match formula in a cell, and when it doesn't find a match it defaults to the first cell in the array. How can I make it return a blank or a zero?

  2. #2
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.95 for Mac MS 365
    Posts
    8,684

    Re: Index / Match Question

    that is a strange index/match, usually if it doesn't find something it returns #N/A, if it finds something in the match section but not the index part it'll return a 0. if you want it to return a blank instead of #N/A then put IFERROR(your (index/match formula),"")
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  3. #3
    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
    53,048

    Re: Index / Match Question

    Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

    Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

    To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    (note: this change is not optional )

    (also, please show us your formula)
    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

+ 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] Quick INDEX MATCH MATCH OFFSET question
    By franb123 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-25-2017, 02:56 AM
  2. INDEX-MATCH Help/Question
    By jlane1994 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-24-2016, 03:37 AM
  3. index match question
    By nawGo in forum Excel General
    Replies: 4
    Last Post: 01-30-2016, 08:54 PM
  4. [SOLVED] Index/Match Question
    By chisox721 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 12-12-2013, 05:15 AM
  5. Index, match, match Question!. Seems so simple but can't figure it out...
    By huikimhuikim in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-12-2013, 01:57 PM
  6. Index/Match Question
    By mikera in forum Excel General
    Replies: 2
    Last Post: 01-07-2010, 07:01 PM
  7. Index/Match question
    By PhilH1982 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 11-01-2007, 08:26 AM

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