whether both of the data (i.e.) Name and zip is present in somewhere of your
workbook?

Like this
Hendersonville, TN 37075

--------------------
(Ms-Exl-Learner)
--------------------



"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.