Auto Populate Fields Based Upon Dropdown Selection

[gsparks]

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.