When Google Forms collects responses, it creates an entirely new row in the Google Sheet which I don't want to happen because I am using a VLOOKUP for another sheet and it's not grabbing the data I want. Ideally, when a response is collected, I don't want it to create a new row but to be in the same row I have created so the vlookup function would work. Any ideas?

  • It's a little unclear what you're asking here - is there an example sheet you can provide? Apr 5, 2019 at 18:46

1 Answer 1


You can (should) use QUERY formula to recollect all your data in your desired format/output and then mine this created QUERY with your VLOOKUP formula. Syntax example:

=QUERY(FormResponses1!A:Z; "select * where A is not null"; 0)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.