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?