Conditional Formulas in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
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!
 
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)
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top