How do I make formulas automatically carry down to the next line when a new form is submitted?
I have a sheet that is being fed by a form. I am using a vlookup to add contact data from another sheet dependent on the email of the person who submitted the form.
I want those vlookups to be added automatically to each line as new forms are submitted.
How do I do this?