Sheet References from multiple sheets

VSLMike

Struggling with cross referencing multiple sheets.

Sheet 1 - is auto-filled by a form from users in multiple areas.

Sheet 2 - contains the standards for one area.

Sheet 3 - needs to pull

from sheet 1 (Task) and (Time) respective to area M1 &
from sheet 2 The (Standard Time) relevant to Stanard Task

I have been attempting to use an Index Match combination but have been unsuccessful.

In help greatly appreciated.

Find more posts tagged with

Formulas

Accepted answers

All comments

Paul Newcome

I would use an INDEX/MATCH on sheet 1 to pull over the data from sheet 2.

Exactly what type of data would you have populated there on sheet 3 and for what purpose?

VSLMike

@Paul Newcome Index / Match is what I have been attempting unsuccessfully. I believe the answer to your question/s are in my initial post. If my request from my initial post is unclear, please let me know. Thanks for the response. I really appreciate it.

Paul Newcome

Exactly what data would you have populated there on sheet 3 and for what purpose? Are you looking for a summary of all M1 entries, or is it just a replica of sheet 1 just with the extra column being pulled from sheet 2?

VSLMike

For every row that has M1 in the area field I need the corresponding task and time replicated / shown in sheet 3.

Then

Then for each row in sheet 3 I need the corresponding standard time from sheet 2 replicated in sheet 3.

Does that make sense?

Paul Newcome

My suggestion would be to add the [Standard Time] column to sheet 1 and do away with sheet 3 altogether.

=INDEX({Sheet 2 Standard Time Column}, MATCH(Task@row, {Sheet 2 Standard Task Column}, 0))

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.