Index/Match formula not working

Kelly Gabel

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

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!

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!

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.