If X, then Y

Hi! Apologies in advance as my excel know-how is quite limited.

My question is an if function.

I have a list of zip codes, and I want to tag them as 'eastside' or 'westside.'

So, if A2 is 90066, than B2 is Westside.

In the case that the zipcode is one of 30 zip codes, I would like to be able to tag "eastside" or "westside" to any of them.

in essence, I have 50 zips, and i want to be able to tag them as one of the two terms.

Thank you for help in advance!

Hi bennythedog,

Can you pls explain how numbers depend on zips in US?

I'm not sure I understand your question.

I have a list of zip that look like this:
90004
90004
90004
90004
90004
90005
90005
90005
90005
90005
90006
90006
90008
90008
90010
90010
90010
90010
90010
90010
90010
90010
90011
90012
90013
90017
90017
90019
90019
90020
90020
90020
90020
90020
90020
90020
90020
90020
90020
90020
90022
90023
90024
90024
90025
90025
90025
90026
90026
90026
90027
90029
90034
90034
90034
90035
90035
90036
90036
90039
90039
90041
90041
90041
90041
90042
90042
90043
90045
90046
90046
90046
90046
90046
90047
90048
90048
90048
90048
90049
90049
90049
90049
90049
90050
90062
90063
90063
90063
90064
90064
90065
90065
90065
90065
90066
90066
90066
90066
90067
90067
90068
90068
90068
90068
90069
90071
90076
90077
90077
90078
90201
90201
90201
90210
90211
90212
90240
90240
90240
90240
90241
90241
90241
90241
90241
90241
90241
90242
90242
90245
90247
90247
90249
90250
90250
90254
90255
90255
90260
90260
90260
90262
90262
90262
90262
90265
90266
90266
90266
90266
90272
90272
90272
90274
90274
90274
90277
90277
90277
90277
90277
90277
90277
90278
90278
90278
90278
90280
90290
90290
90291
90291
90301
90301
90305
90401
90403
90405
90405
90501
90501
90501
90501
90501
90501
90501
90501
90501
90501
90502
90503
90505
90505
90505
90505
90505
90505
90510

Each zip corresponds with a different part of Los Angeles. I would like to mark that as either "Eastside" or "westside"

Does that make sense? Thank you for inquiring!

Hi,

Attached is an example using the Zip Codes you provided. You will need to provide one set of Zip Codes that represents "Westside" of Los Angeles and enter them in column F.
I googled the heck out of East and West Los Angeles and couldn't find a definitive list of Zip Code for one particular side or the other.

The current set of Zip codes representing the "Westside" of Los Angeles were derived from latitude and longitude of the zip codes as listed on:

http://www.geonames.org/postal-codes...alifornia.html


I have given column F a name of "Westside.

This formula starts in B2 and is copied down.

Formula:

Please Login or Register  to view this content.

Cheers

wow, thank you so muhc for your help!!!