CODEWITHSUNDEEP
autofill
Hemen Samex Agency
Hemen Samex Agency

Reputation: 11

How to autofill data in google sheets based on values in a column

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.

I have a master sheet of all the students' names, IDs and addresses.

Upvotes: 1

Views: 13308

Answers (1)

Nitin Dhomse
Nitin Dhomse

Reputation: 2622

You can use VLOOKUP functionality of Google spreadsheet, if you are having master data in one sheet and you want to auto fill other based on Id or any field from your dropdown, VLOOKUP is the best solution Link : See documentation

Upvotes: 1

Related Questions