CODEWITHSUNDEEP
google-sheetsspreadsheetgoogle-formsformulas
Amit
Amit

Reputation: 87

stop google sheets creating new row when new data is entered in the form

I have got a Google Spreadsheet that is using a lookup function to lookup name from another sheet according to their ID number but when the ID is entered using the submit form it creates a new row each time and therefore nothing is looked up from the other form.

This is my lookup function currently 

=VLOOKUP(C2,'Student Details'!A:D,2,FALSE)

But I have also tried following other examples and put in:

=ArrayFormula(VLOOKUP(C3,'Student Details'!A:D,2,FALSE))

None of these formulas are working for me could someone please advice me where i am going wrong.

Thank you

Upvotes: 1

Views: 2223

Answers (1)

JPV
JPV

Reputation: 27262

Try using a range in your arrayformula. E.g: in row 2 try:

=ArrayFormula(IF(LEN(C2:C), VLOOKUP(C2:C,'Student Details'!A:D,2,FALSE),))

make sure the column where you want to use this formula is empty (no data or formula) from row two onwards.

Upvotes: 2

Related Questions