Index/Match formula not working

Hey community!

I've been using this Index/Match formula for a while now and suddenly, when I copy/paste it into a new sheet from my template sheet, I am getting an #INVALIDREF error. I didn't change anything and I have confirmed that it is pointing to the correct references so I don't know what is going wrong.

Is there anything that looks wrong about this formula?

Anything that might be causing it not to work suddenly?

=INDEX({SF Phase Mapper Range 2}, MATCH([Active Stage]@row, {SF Phase Mapper Range 1}, 0))

Thanks! and Tagging my formula guru @Paul Newcome for visibility!

Kelly

Find more posts tagged with

Accepted answers

Andrée Starå

Hi @Kelly Gabel

I hope you're well and safe!

When you copy a so-called cross-sheet formula, you have to add the Sheet References to the new sheet manually, or it will not work.

Make sense?

Did that work/help?

I hope that helps!

Have a fantastic weekend & Happy New Year!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

All comments

Andrée Starå

Hi @Kelly Gabel

I hope you're well and safe!

When you copy a so-called cross-sheet formula, you have to add the Sheet References to the new sheet manually, or it will not work.

Make sense?

Did that work/help?

I hope that helps!

Have a fantastic weekend & Happy New Year!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

Kelly Gabel

@Andrée Starå thanks! I had actually already done that and it still wasn't working which was why I was so confused!!

I ended up restarting my computer and it seems to be fixed now... LOL Must've been something weird in the cache.

Thanks so much!

Kelly

Andrée Starå

@Kelly Gabel

Glad you got it working!

Happy to help!

✅Please support the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Paul Newcome

@Kelly Gabel Haha. Thanks for the shout-out. It looks like it was just a bit of a gremlin though which fortunately worked itself out relatively quickly. Glad it is all sorted now.

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.