G
Guest
If anyone can help me with this formula, I will be very grateful.
I am manipulating a mailing list in Excel and I want the correct city to
populate a field, according to the Zip Code entered in another field. For
instance, if the Zip Code entered into A1=90272, the City in B1 should equal
"Pacific Palisades" - If the Zip Code entered into A1=90402, the CIty in B1
should equal "Santa Monica" and so on. There are going to be about 5
different Zip Code possibilities in the whole list.
I am guessing that it will be some variation of a formula like this entered
into B1:
=IF(A1=90272,"Pacific Palisades") but I don't know how to write the formula
for multiple Zip Code and City combinations.
Can anybody help??
Thanks!
I am manipulating a mailing list in Excel and I want the correct city to
populate a field, according to the Zip Code entered in another field. For
instance, if the Zip Code entered into A1=90272, the City in B1 should equal
"Pacific Palisades" - If the Zip Code entered into A1=90402, the CIty in B1
should equal "Santa Monica" and so on. There are going to be about 5
different Zip Code possibilities in the whole list.
I am guessing that it will be some variation of a formula like this entered
into B1:
=IF(A1=90272,"Pacific Palisades") but I don't know how to write the formula
for multiple Zip Code and City combinations.
Can anybody help??
Thanks!