+ Reply to Thread
Results 1 to 2 of 2

Compare 2 lists and return value

  1. #1
    Registered User
    Join Date
    04-11-2012
    Location
    Utah
    MS-Off Ver
    Excel 2007
    Posts
    1

    Compare 2 lists and return value

    I'm working on generating an accurate list of Cities and Zip Codes within a given state (plus additional data). I have 2 separate lists where one contains more of the desired data but no zip codes and the other list contains no desired data except for the zip codes. Obviously i'd like to use the more detailed list but i still need the zip codes. I've pasted both lists in one workbook but on 2 separate sheets. The first problem i'm running in to is that the list of Cities i have is more comprehensive (2764 cities) than the list of cities with zip codes (1036 Zip Codes 814 Cities - some duplicates per zip code). i would like to compare the 2 lists and if a city name from the list i have is located on the second list, return the associated zip code. the format my data is in looks like this.

    My City New City New Zip
    Sheet2!F2 Sheet3!A2 Sheet3!B2

    Any suggestions on how to accomplish this would be greatly appreciated
    Thank you!

  2. #2
    Forum Expert icestationzbra's Avatar
    Join Date
    01-07-2004
    MS-Off Ver
    2007, 2010
    Posts
    1,421

    Re: Compare 2 lists and return value

    recommended to upload a spreadsheet with some representative data (worst case scenarios preferred)...
    - i.s.z -
    CSE, aka Array aka { }, formulae are confirmed with CONTROL+SHIFT+ENTER.
    Replace commas ( , ) with semicolons ( ; ) in formulae, if your locale setting demands.
    All good ideas are courtesy resources from this forum as well as others around the web.
    - e.o.m -

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1