Formula returning #nomatch when flash filled (original formula does not have error)

Hello - I wrote an IF(Index(Match formula to reference a checkbox between 2 sheets (if checked in reference sheet, check in target sheet). The original formula works, but when I attempt to fill the formula down my column, it starts throwing #NOMATCH errors. I tried re-typing the formula from scratch, but no luck.

Target sheet:

Reference sheet:

Any ideas?

Find more posts tagged with

Formulas

Accepted answers

Natalia Kataoka

I have figure it out! Had a "." snuck in on the target sheet that was not on the reference.

All comments

Natalia Kataoka

I have figure it out! Had a "." snuck in on the target sheet that was not on the reference.

Genevieve P.

Hi @Natalia Kataoka

I'm glad you figured it out! Thanks for sharing your solution.

Cheers,

Genevieve

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.