Best formula to link data in another cell

Hi all, I wanted to know what the easiest way would be to link data from one sheet to another. I have working cross-reference formulas, cell-link, and even just using miscellaneous formulas to reference them, just as proof of concept. I was wondering, what is the difference between using Index-Match to pull in data, versus using a cell link. Say the data may change or move around, which one would be preferable to ensure that the data is accurate consistently? Could I reference a report within in a sheet to find the exact information I need?

Any additional information would be great, thank you!

Find more posts tagged with

Cell linking

Accepted answers

All comments

Paul Newcome

Cell links and INDEX/MATCH are two very different features.

Cell links are completely manual and are used to bring in a specific cell's data from another sheet.

INDEX/MATCH can be applied as a column formula to make it completely automatic, and it is designed to bring in data from one column based on a match of data in another column (a lookup basically).

You cannot reference a report inside of a sheet though.

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.