+ Reply to Thread
Results 1 to 4 of 4

INDEX Help to Show Blank

Hybrid View

  1. #1
    Registered User
    Join Date
    07-14-2022
    Location
    Dallas
    MS-Off Ver
    Office 365
    Posts
    4

    INDEX Help to Show Blank

    I had help earlier on find this spreadsheet and thought everything was working fine however I just found out that it is not.

    The way my current spreadsheet is, I need help in having it return a blank cell if the result is 0.

    Current formula is: =IF(V3="","",INDEX(SORT(FILTER($B$3:$U$1001,$D$3:$D$1001=V3),20,-1),1,1))

    In some cases, the All Hits column equals zero and if that is the cas, then I want it to display a blank or something similar instead of the location. I apolgize with how I'm wording this and hope that you are understanding.

    I'm using Office 365 version of Excel

    Thank you in advance.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    office 365
    Posts
    3,187

    Re: INDEX Help to Show Blank

    Maybe:

    X3 and down:
    =LET(A,INDEX(SORT(FILTER($B$3:$U$1001,$D$3:$D$1001=V3),20,-1),1,20),IF(V3="","",IF(A=0,"",A)))
    Last edited by Limor_OP; 07-15-2022 at 04:48 PM.

  3. #3
    Registered User
    Join Date
    07-14-2022
    Location
    Dallas
    MS-Off Ver
    Office 365
    Posts
    4

    Re: INDEX Help to Show Blank

    Perfect! Thank you so much!

  4. #4
    Forum Expert
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    office 365
    Posts
    3,187

    Re: INDEX Help to Show Blank

    You're welcome taysue.

+ 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] When Index Match is blank, I want it to show a value from another cell
    By Frank Batson in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-30-2021, 11:46 AM
  2. Force INDEX SMALL ROW Array to Show Zero/Blank Rather Than 'Skipping' Result
    By EduardStoo in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-12-2019, 09:52 AM
  3. [SOLVED] Problem dictionary to listview not show first index and not show date
    By daboho in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-25-2018, 01:51 PM
  4. [SOLVED] show cell blank instead of 0 or error after index match formula
    By tabkaz in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-23-2016, 01:46 AM
  5. If (average A1:A10 - 10) = >0, show answer, if not, show blank... Without helper
    By ThomasCarter in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-15-2012, 10:53 AM
  6. 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
  7. if formula to show blank or show instead of displaying the running total
    By js1978 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-10-2008, 04:38 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1