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!

One way:

List, perhaps in a second sheet, your zips in column A and cities in
column B. Then use

B1: =VLOOKUP(A1,Sheet2!A:B, 2, FALSE)

In article ,
"JFenley" wrote:

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.

The number of combination probably far outweigh Excel's nested formula
capability.

Instead, build a table in say H1:In, where H contains the Zip code, and I
the City.

Then in B1, simply use

=VLOOKUP(A1,$H$1:$I$100,2,False)

the 100 would be the size of the table

--

HTH

RP
(remove nothere from the email address if mailing direct)


"JFenley" wrote in message
...
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!

Have a look at HELP index for vLOOKUP. Set up a table and use it.

--
Don Guillett
SalesAid Software

"JFenley" wrote in message
...
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!