Cross sheet reference,

I'm writing to you because I'm having some trouble with cross sheet reference formulas. I lost all of the formulas in my sheet, and now when I try to add a new one, it works fine for the first row, but when I drag it to another row, it says "no match." I'm sure that the formula was working fine before, but I'm not sure what's wrong with it now.

Can you please help me troubleshoot this issue? I'm really not sure what else to do.

=INDEX({stocksupplier}, MATCH(CODE@row, {stockcode}))

It works fine for First Row, the movement i drag it t apply to another row it Says "~NO MATCH

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

Try specifying an exact match in your MATCH function:

=INDEX({stocksupplier}, MATCH(CODE@row, {stockcode}, 0))

You can also look through your activity log to find the formula used and copy/paste from there.

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.