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

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.