INDEX MATCH needs to pull blank if there's nothing in the cell

I'm currently writing a formula to pull the data from one sheet to another. My formula pulls the data in if there's information in the cell. If there's nothing in the cell it returns "#NO MATCH". How do I get it to return nothing if there's nothing there instead of NO MATCH?

Here's my current formula-

=(INDEX({RPA Last Name}, MATCH([Row ID]@row, {RPA ID}, 0)

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

You need an IFERROR

=IFERROR(original_formula, "")

Zachary Hall

@Siobhan16

Try:

IFERROR(INDEX({RPA Last Name}, MATCH([Row ID]@row, {RPA 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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.