title: How to autofill data in google sheets based on values in a column
body: <p>I have a column with a drop down list of the names of the students.
  I want the other columns to read the name of the student written in the column from the drop down list and fill in the ID code of the student and the student address automatically.</p>
  
  <p>I have a master sheet of all the students' names, IDs and addresses.</p>