+ Reply to Thread
Results 1 to 3 of 3

IFERROR Index and Match formula not returning expected result

  1. #1
    Forum Contributor
    Join Date
    01-28-2013
    Location
    Spencerport, NY
    MS-Off Ver
    Excel 2016
    Posts
    270

    IFERROR Index and Match formula not returning expected result

    Hello All

    Can anyone shed some light on an issue I am having using a IFERROR INDEX AND MATCH formula

    I believe I have the correct formula, but not getting the results I expected.

    As you can see in the attachment , I am expecting to return a "BLANK" cell when there is nothing in the index and match formula , but yet I am returning a 0 ( Highlighted in yellow)
    Any ideas where I went wrong ?

    Thanks in advance
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,597

    Re: IFERROR Index and Match formula not returning expected result

    Index will return 0: you can hide zeros by formatting Cells as:

    0;-0;;@

  3. #3
    Forum Contributor
    Join Date
    01-28-2013
    Location
    Spencerport, NY
    MS-Off Ver
    Excel 2016
    Posts
    270

    Re: IFERROR Index and Match formula not returning expected result

    Thanks so much John !

+ 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. IfError(VLookup Not Returning Expected Result
    By dgarber in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-24-2021, 09:40 PM
  2. Index & Match not returning expected result
    By patch64 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-29-2018, 09:24 AM
  3. [SOLVED] Problem with index/match formula - not returning expected results
    By gsdanger in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-16-2018, 12:50 AM
  4. [SOLVED] INDEX MATCH formula not returning expected result
    By lukela85 in forum Excel General
    Replies: 4
    Last Post: 12-18-2017, 11:23 AM
  5. [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
  6. [SOLVED] IFERROR+INDEX+MATCH Formula is not returning the correct value
    By bxk006 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-16-2013, 09:50 AM
  7. Replies: 4
    Last Post: 07-02-2013, 09:47 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