Show form field based on a selection

I have a spreadsheet with 250 Last Names, Addresses and Zip Codes. I would like to have a drop down box with the last names and then when one is selected, the address and zip code are prepopulated in another field or even in a text field.  It would cut down on redundant steps

Conditions work GREAT, but only on a few things, it would be nice to incorporate the table so I can have the 250 names (or any mid-sized data set) without having to set up all of the conditions.

Hi, your escenario would require hiring a programmer, and using the full source code of your form, to make the connection to a database, and make the queries to pull the information accordingly to the names.

Jotform´s philosophy is to keep things simple, so adding 250 names in a Dropdown field,  250 Text Area fields, and then setting 250 conditions to show a specific Text Area field based on a selection, may not be a good solution, and could cause some conflicts due to too many conditions.