Thursday, February 1, 2018

yogi_Pull Multiple Entries From Form Reponses Sheet Entered Together In Rows

Google Spreadsheet   Post  #2357

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Jan-28-2018
question by N2k
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/6LtBRfXU7OQ;context-place=forum/docs
Struggling with INDEX and MATCH to pull data from another sheet
Hi all,

I've been looking for a way to import user Google Forms responses into my database automatically, however the problem I've run into is that I have a lot of repeating blank column due to repeating sections.

I would like for the Form Responses to be pasted into the correct row when the RMA number given in the Please enter your provided RMA reference section matches the row in MainData sheet, returning the relevant company, customer, device type, serial, site and fault reported fields.

However I've been struggling with achieving this with QUERY as I cannot edit things the next row below, or make it loop, so that if fills in Yes to another RMA reference, the same contact details get added to the row below.

I've thought of using INDEX and MATCH but I have no idea where to start! Here's a sample sheet:


Any help is MUCH appreciated!