Help with using index and match to reference other sheets.

I am trying to create logs for our operators to use on two different operations. One operation always happens before the other operation. So operation 2 will reference the sheet of operation 1 and pull data over and have it all end up on the same line. This was working well until I tried to make a new sheet.

Now when I change the column I am referencing all columns in the entire sheet change to match that new reference. These are column formulas. Why are other columns changing when I modify a single column?

How do I make it so only the column formula I am working on changes and not all columns in the sheet that have different referenced columns?

Find more posts tagged with

Accepted answers

Jared P

So I think my issue is copy/paste. Being lazy and copying my formula to another column and then changing it will change all column formulas. Typing out a new formula seems to fix the issue.

All comments

Jared P

So I think my issue is copy/paste. Being lazy and copying my formula to another column and then changing it will change all column formulas. Typing out a new formula seems to fix the issue.

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.