I'm inputting addresses into an worksheet and some of the city names are related to only one zip code. Ideally I'd like to enter Ponte Vedra Beach into k2 and have 32082 appear in M2. If I input anything else, then I'd simply like to be able to type in the correct zip code. I don't normally work with IF statements, but I looks as if I should be using a Value_if_true statement.

Is that correct and if so should the statement look something like this:
=IF(k2="Ponte Vedra Beach","32082") Except that is missing where the 32082 should be displayed.

Thanks for any help.

Jon