How to keep a cell blank if there is no data?

I have two sheets a master (2800 records) and a feeder (270 records). I am using the following formula to update a column called scheduled date on the master:

=INDEX({feeder06262021 Range 1}, MATCH(IP@row, {feeder06262021 Range 2}, 0))

Which works bringing the date in, however the majority of the cells on the master sheet are not found in the feeder and the results get posted as #NO MATCH. Which I don't want to see. I would like to the cell to be blank or have the date from the feeder. So how do I incorporate a IF THEN or some sort of true statement to achieve what I am looking for, either a date from the feeder sheet or just be blank?

Find more posts tagged with

Formulas

Accepted answers

Kelly Moore

Hi @ed.jaro

You should be able to use the IFERROR function to keep the cell blank.

=IFERROR(INDEX({feeder06262021 Range 1}, MATCH(IP@row, {feeder06262021 Range 2}, 0)),"")

Notice your entire formula is wrapped within the IFERROR.

Does this work for you?

Kelly

All comments

Kelly Moore

Hi @ed.jaro

You should be able to use the IFERROR function to keep the cell blank.

=IFERROR(INDEX({feeder06262021 Range 1}, MATCH(IP@row, {feeder06262021 Range 2}, 0)),"")

Notice your entire formula is wrapped within the IFERROR.

Does this work for you?

Kelly

ed.jaro

These worked perfectly! Thank you so much.

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.