April wrote:
But I am do a function like this - if column A equals Hendersonville, TN,
then I want Excel to automatically enter the zip of 37075.

How would I write that? Thanks for the help.


But Hendersonville has two zip codes...37075 and 37077. And what about
Nashville, which lists 37201 through 37222, 37224, 37227 through 37230, 37232
and 37234 through 37250 for a total of 45 options.