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?



  • Amanda Alv
    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
    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.