Spreadsheet to form: How to pull data based on selection made on another field?

HI, Just wondering how I can use a spreadsheet to populate a field based on an answer to a previous field. For example species of animal have a common name and a scientific name. I have created a dropdown list of common names but I want the jotform to look at that name and then select the appropriate scientific name from the excel spreadsheet and insert that into a another field. There are over 100 names so I didn't want to create a conditional logic for each option.

my form is: https://www.jotform.com/build/200647457102853#preview

It's not possible to insert values without using conditions; however, I found a workaround that will require one condition only and it works with the Spreadsheet to Form widget. 

You may add your list to a drop down field and set an unique ID (preferably numbers only) and conditionally insert the ID for the selected option into the Spreadsheet to Form widget. 

This guide will help you setting the IDs as calculation values: https://www.jotform.com/help/301-How-to-Assign-Calculation-Value 

This guide will help you copying the value from one field to another: https://www.jotform.com/help/286-How-to-Pass-Field-Value-to-Another-Field 

However, note that this will still require to click on the widget's button to pull the data. 

If you have questions, let us know. 

It's not possible to insert values without using conditions; however, I found a workaround that will require one condition only and it works with the Spreadsheet to Form widget. 

You may add your list to a drop down field and set an unique ID (preferably numbers only) and conditionally insert the ID for the selected option into the Spreadsheet to Form widget. 

This guide will help you setting the IDs as calculation values: https://www.jotform.com/help/301-How-to-Assign-Calculation-Value 

This guide will help you copying the value from one field to another: https://www.jotform.com/help/286-How-to-Pass-Field-Value-to-Another-Field 

However, note that this will still require to click on the widget's button to pull the data. 

If you have questions, let us know. 

Thanks that worked beautifully.