Formula Errors with Index match

I'm trying to get an index formula to look up the employee ID and return the project they are assigned to on another sheet. The issue is that if the ID is blank, its returning the first project in the list with no ID #. I thought the IFERROR would take care of that but it isn't. Any suggestions?

=IFERROR(INDEX({Proj_Name}, MATCH([*]@row, {Primary Super_ID}, 0)), "")

Here is the formula I have ^^

Find more posts tagged with

Accepted answers

All comments

Jeremy_D

You could use an ISBLANK formula to say that if the ID is blank then to produce a blank result. So it would look something like this:

=IF(ISBLANK([*]@row), "", INDEX({Proj_Name}, MATCH([*]@row, {Primary Super_ID}, 0)))

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.