I have a spreadsheet of almost 1000 company names in column A and their associated codes in column B. I want to setup a survey so that when someone enters the branch code into a text entry question on page one, their company’s name is piped into a question on the next page.
Using auto-complete almost does what I need. The issue is that I don’t want customers to see the names of any other companies auto-populate as they’re typing. My company doesn’t like making their client list easy to find. If it was a smaller list, I’d just use branching choices/display logic, but I can’t think of a quick way to set that up for almost 1000 entries.