+ Reply to Thread
Results 1 to 3 of 3

show cell blank instead of 0 or error after index match formula

Hybrid View

  1. 04-22-2016, 09:04 AM #1
    JohnTopley
    JohnTopley is online now
    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
    30,965

    Re: show cell blank instead of 0 or error after index match formula

    =IFERROR(INDEX($F10:$M10,MATCH(P$7,$F$7:O$7,0)),0) format cells as 0;0;;@ if you want to hide zeros
    Last edited by JohnTopley; 04-23-2016 at 04:23 AM.
    Reply With QuoteRegister To Reply
  2. 04-23-2016, 01:46 AM #2
    tabkaz
    tabkaz is offline
    Registered User
    Join Date
    02-27-2012
    Location
    UK
    MS-Off Ver
    Excel 365
    Posts
    65

    Re: show cell blank instead of 0 or error after index match formula

    thanks
    it working now
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Index/ Match Formula, How to return blank cell as a blank not 0
    By MDResearcher in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 02-24-2016, 08:40 PM
  2. [SOLVED] Need cell with formula to show as blank instead of error message when no data is entered
    By jaiverson in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-05-2016, 09:15 PM
  3. [SOLVED] Blank Cell with Error If/Index/Match/Iserror
    By jespo1351 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-13-2014, 10:19 AM
  4. I want to exclude blank cell in index match formula with multiple criteria
    By NOOR8225 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 09-16-2013, 06:51 AM
  5. [SOLVED] Concatenated INDEX MATCH formula that won't give error that can index match 2-4 strings
    By bkwins in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-02-2013, 01:31 AM
  6. [SOLVED] An INDEX MATCH formula has blank cell - need to ignore or delete
    By rls231 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-26-2013, 11:13 PM
  7. Index Match: Show blank instead of #NA for no match
    By cedarhill in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-20-2011, 03:21 PM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1