I have a drilldown question with two dropdowns: State and City. Separately, I’ve uploaded a supplemental data file containing Unique ID, State, City, and other additional fields. Unique ID, State, and City have all been set as search fields.

I want the respondent to select State, then City, from drilldown question, then based on the selection look up values from additional fields and then pipe text into latter questions. 

This seems to work with a multiple choice question as there is only one field that can be used as the lookup value but not with two dropdowns.

Thanks in advance for your help.