Checking to see if value in cell equals one of many numbers

[brjv42]

I am working on a mailing list and I was wondering if there is a line of code that will look at a cell, see if it has one of many zip codes in it, and then spit out the county.

Example:
I have a county that has 5 zip codes in it: 47558, 47501, 47519, 47568 & 47562.

They are all speratically placed in a column throughout the spreadsheet.

I need a piece of code that will look through that column, see if the zip codes match, and then put the county "DAVIESS" in the next column.

I know that this can be done with an IF statement, but the problem is that I have six different counties that I am looking for and each have at least 5 zip codes within the county.

If anyone can help, I would greatly appreciate it.

 

[Andrew Poulsom]

Make a list of the zip codes with the county in the next column, say on Sheet2 A1:B30. Then you can use a formula like this:

=VLOOKUP(B2,Sheet2!A1:B30,2,FALSE)

where B2 contains the zip code whose county you want.

 

[brjv42]

Thanks, that helped!