In one of our surveys, we're asking for respondents' ZIP codes.



We'd then like to ask them a question about how they would allocate money between the national government and the state government, and then between the state government and the city government. The first question's simple since we're only surveying respondents in the United States and ask them explicitly for the state they live in earlier in the survey. But for the second question (something like "how would you split $X between the government of Alaska, and the government of Juneau", for example), we don't necessarily want to explicitly ask people for the city they live in as well (it's a last-resort option).



So given that, I've been able to find some spreadsheets that map ZIP codes into the corresponding "town" or "city", but of course there's 40,000 + ZIP codes, easily hundreds if not thousands of which may come up in our survey. So is there some method by which I can take the user's input (their ZIP code), and find that in an array somewhere in Qualtrics that contains the ZIP code and the corresponding town/city?



I know that Authenticators basically just check some list/ spreadsheet for an email, for example, so is there a way to do this same thing but for ZIP codes and a corresponding "ZIP Code list" (as opposed to a contact list), that I could use to pull out the name of the respondent's town or city? I know also validation for text entry can check that a user's input is actually a valid US postal code, so presumably Qualtrics already has some sort of list in the background checking that the user's input matches one of the ZIP codes there?