How to replicate/transfer data between two sheets based on stipulated criteria.

This is a workflow type of question that I would very much appreciate help with, to try and resolve with a formula...

I am using a form built in "sheet 1" to collect self-reported data on whether applicants meet a requirement "A." Those who respond "yes," submit a second form (built in a separate sheet, "sheet 2"), within which they provide proof that they in fact meet the requirement. Both sheets will have the applicant's name, and sheet 2 will have a "Requirement 'A' Met?" column to be populated "Yes" or "No" based on supporting info submitted.

Is there a way to replicate the "Requirement 'A' Met?" column from sheet 2 into sheet 1, getting the column in sheet 1 automatically populated when the column in sheet 2 is changed?

Is there a way to have a formula on sheet 1 that says "if applicant's name on sheet 1 matches applicant's name on sheet 2, return the value on 'Requirement 'A' Met?'" column in sheet 2?

Thank you very much in advance!

Find more posts tagged with

Accepted answers

Paul Newcome

You would use an INDEX/MATCH.

=INDEX({Sheet 1 Column To Pull From}, MATCH([Name Column]@row, {Sheet 1 Name Column}, 0))

All comments

Paul Newcome

You would use an INDEX/MATCH.

=INDEX({Sheet 1 Column To Pull From}, MATCH([Name Column]@row, {Sheet 1 Name Column}, 0))

Barbara Silva

Thank you SO much, @Paul Newcome!! Greatly appreciated!!!

Paul Newcome

Happy to help. 👍️

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.