INDEX/MATCH - I want to return a blank cell if another cell is also blank

Hello, thanks in advance for the help.

I am using a DISTINCT formula.

Then I have an INDEX/MATCH formula in the next cell, pulling in from a different sheet. I have the IFERROR part programmed, but I would also like it to give a blank cell result if there is not a number in the "Harvest Batch Name" column. This way, If I haven't yet assigned a name, it won't pull in anything for the "Immature plant batch UID". Is there another part of the function that will allow me to tell it to leave it blank if the other cell is also blank?

Thanks so much!

Find more posts tagged with

Formulas

Accepted answers

All comments

Genevieve P.

Hi @Sarah_lee123

Yes! You can add an IF statement at the very beginning before your formula to first check if the cell is blank:

=IF([HARVEST BATCH NAME]@row = "", "", formula

Let me know if that makes sense or if you'd like to see the full formula spelled out.

Cheers,

Genevieve

Sarah_lee123

@Genevieve P. I apologize, but I do need it spelled out for me. I tried to figure it out, but I am still pretty green when it comes to formulas.

Thanks so much.

Genevieve P.

Hi @Sarah_lee123

No problem at all 🙂

=IF([HARVEST BATCH NAME]@row = "", "", IFERROR(INDEX({IMMATURE BATCH ID}, MATCH([HARVEST BATCH NAME]@row, {HARV BATCH NAME}, 0)), ""))

This way the formula will first look to see if the cell is blank or = "", then if it is, it will return a blank cell, "", otherwise if that cell is not blank, it will then go through your Index(Match formula.

Let me know if this now works for you!

Genevieve

Sarah_lee123

@Genevieve P.

That worked

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.