Auto Populate Fields Based Upon Dropdown Selection

11 views
Skip to first unread message

gsparks

unread,
Feb 28, 2017, 11:10:58 AM2/28/17
to
I am creating a Google Sheets document that is a 4-year plan for high school students. We need to select a Student Pathway that will trigger four preset courses that the student will need to take. Those courses should go into four fields in different columns. The form can be found at https://docs.google.com/spreadsheets/d/1N3J0wcLm0a65h_z0xSrO9rqsqWXmejXy-hlucOmbzFs/edit?usp=sharing.

I want B3 to auto-populate B11, D10, F10, and H10 with information from the Google Sheet found at https://docs.google.com/spreadsheets/d/1C7acxeQrVdK0FOv_lKBZei4nGgxgrKgQSRj1UW9FpxE/edit?usp=sharing.

Row 1 will be the choices that will be in the dropdown in B3.

Thanks in advance for all assistance!

--

*----------This message originated from Gaston County Schools.* All e-mail
correspondence to and from this address is subject to the North Carolina
Public Records Law as defined under N.C.G.S. §132.1, which may result in
monitoring and disclosure to third parties, including law enforcement and
the media.
Reply all
Reply to author
Forward
0 new messages