Is there is a way to pull specific data from the spreadsheet?

Is there is a way to pull specific data from the spreadsheet based on a dropdown property?

Unfortunately no it is currently not possible to populate form fields from any external source or previous submission data.

I would suggest you to please take a look at our "Spreadsheet to form" widget and see if that fits into your requirement. It will allow you to upload excel file in the widget where users can search for a record based on unique code. You may also like to take a look at the following guide which should help you:  https://www.jotform.com/help/442-How-to-Use-the-Spreadsheet-to-Form-Widget  

Hope this helps.

Do get back to us if you have any questions.