Can a Form Pull Info

I would like to create a form that uses the entries from 1 column in a sheet in a drop box. Once a selection is made the remaining fields in the form populate with associated info from the sheet. Is this possible? It's similar to the dynamic view, but essentially want the detail page to be the form, and one of the field to be a drop down box and when someone makes a selection every other field populates.

Answers