Macros If Then Statement

I have a list of Zip codes and I need to make it so if they type in their Zip code and it matches a range of cells on another worksheet then they get a specific phone number but if it matches a different range of cells then they get a different phone number to call. If it doesn't match any of the zip codes in the database then they receive a 3rd phone number. Is this possible?

It will be good if you explain your question with the help of a sample file.

To Attach a File:

1. Click on Go Advanced.
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.