+ Reply to Thread
Results 1 to 6 of 6

Index Match & Isblank

  1. #1
    Registered User
    Join Date
    03-26-2019
    Location
    Bristol, England
    MS-Off Ver
    Office 2016
    Posts
    3

    Index Match & Isblank

    Hey I'm trying to generate a list of names based on whether the next column is blank or not.


    =INDEX(D4:D39,MATCH(ISBLANK(H4:H39),0))

    It's giving me N/A or sometimes #NAME?
    I've been using Ctrl+Shift+Enter but that doesn't work

    D4:D39 list of names
    H4:H39 list of dates

    So the idea is, if the date is blank, then It'll list the names of the people who haven't inputted a date (and therefore haven't completed it)
    I would need it so if a date was later input, their name would be removed from the list.



    Thanks in advance,

    Joe
    Last edited by joeocall123; 03-27-2019 at 12:05 PM. Reason: attempt to remove attachment

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,482

    Re: Index Match & Isblank

    Hi & welcome to the board
    How about
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    03-26-2019
    Location
    Bristol, England
    MS-Off Ver
    Office 2016
    Posts
    3

    Re: Index Match & Isblank

    Hi Fluff,

    Thank you for your quick response. Shamelessly threw it straight in.

    I'm guessing it's throwing an error as I'm just getting blank cells.
    Is there any more info you would like me to provide which could help you help me?

    Thanks again

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,482

    Re: Index Match & Isblank

    A workbook would help.

    Remember to desensitize the data.

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

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

    Re: Index Match & Isblank

    are you trying to get a count of those without dates or a list of the names where dates are not present?
    if the former then you need a different formula, if the latter then I tested what Fluff gave you and it worked on my limited list, I just changed the ranges for mine but it returned the two names shown where there were no dates across from them.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  6. #6
    Registered User
    Join Date
    03-26-2019
    Location
    Bristol, England
    MS-Off Ver
    Office 2016
    Posts
    3

    Re: Index Match & Isblank

    The latter is what I'm trying to achieve.

    I'll desensitise it and send it over in a small while. You guys are the greatest.
    I have had a fiddle with the function provided and changed the ranges but that didn't prove successful.

    Thanks again.

+ 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] Use Index Match with an ISBLANK?
    By triggfamily5 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 11-07-2020, 08:43 AM
  2. Problem with index, match and isblank
    By skaffapingvin in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-30-2018, 08:44 AM
  3. [SOLVED] Help with Index/ISBLANK
    By mango2015 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-28-2018, 03:17 AM
  4. [SOLVED] Help with IF, INDEX, ISBLANK
    By Ambience247 in forum Excel General
    Replies: 3
    Last Post: 07-17-2017, 04:13 PM
  5. Replies: 6
    Last Post: 04-30-2014, 02:42 AM
  6. Replies: 6
    Last Post: 11-08-2013, 10:29 PM
  7. wrong in ARRAY INDEX,IF, ISBLANK Formula
    By paradise2sr in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-10-2013, 02:35 AM

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