using index match to automatically pull newly created cell data from form

I have been successful at pulling previously populated cell data from sheet A which is auto-populated by Form A to populate specific cells in sheet B; however, I have not been able to find a way to automatically pull newly populated data coming in from Form A or a recurring/cyclical basis (e.g. anytime a new form entry is filled, the specific cells I need to be copied, are copied and pasted to the specific cell locations needed.

I am currently using this formula within Sheet B: =INDEX({Sheet A - Support Request Range 3}, MATCH({Sheetname A- Support Request Range 2}, {Sheetname A - Support Request Range 5}, 0))

Works for populated data but is not looking for new data coming in from Form A. Thoughts?

Find more posts tagged with

Formulas

Accepted answers

All comments

Amanda Alv

Hi there,

Are you selecting the entire column (including the column header) when selecting your reference sheet range? That will allow it to look at the entire sheet and not just the currently populated data.

Let me know if that helps or if I am missing something on how you're using your reference data.

BillDav

yes I am selecting the entire column, including header when selecting the reference; however, if I populate the formula down the destination spreadsheet; it was not picking up test data that I populated on the source spreadsheet.

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.