Share via

VLOOKUP Issues

Anonymous
2019-05-10T19:49:47+00:00

I have struggled half the day with trying to find a way to get this to work.  I have a table of all of the ZIP codes (column A) with their corresponding cities (column B) and counties (column C).  I have a separate list of ZIP codes where I want Excel to auto-list the corresponding county (column C).  I have tried multiple formulas and none of them seem to be working.  The most recent one I used is listed below.

=IFERROR(VLOOKUP(G9,ZIPCOUNTY,3,0),VLOOKUP(G9&"",ZIPCOUNTY,3,0))

G9 = Single ZIP in separate list

ZIPCOUNTY = A1:C534

Any help would be greatly appreciated!  Thank you.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

12 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2019-05-14T14:16:19+00:00

    Hi,

    The "numbers" in G9:G12 are stored as text and that is causing the VLOOKUP to fail. Try: 

    =IFERROR(VLOOKUP(G9*1;ZIPCOUNTY;3;FALSE);"")

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2019-05-13T16:00:12+00:00

    Unfortunately, this did not work.  It ended without errors, but the cell returned with a blank result, rather than the associated County.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2019-05-13T05:43:25+00:00

    Hi Bulletough85,

    Have you tried above formula? Do you need further assistance?

    Regards,

    Waqas Muhammad

    Was this answer helpful?

    0 comments
  4. OssieMac 48,001 Reputation points Volunteer Moderator
    2019-05-10T21:07:43+00:00

    The formula below should work. It will return a found zip code or a blank if the zip code is not found.

    However, the Number Format of the Zip codes in the table and in G9 must be the same. ie. If the Number Format in the ZIPCODE table is Text and the Number Format in G9 is a Number or General and therefore G9 is a Number and NOT TEXT then Vlookup will not find it and will return a blank. This is a very common problem experienced by Excel users.

    =IFERROR(VLOOKUP(G9,ZIPCOUNTY,3,FALSE),"")

    Was this answer helpful?

    0 comments
  5. Anonymous
    2019-05-10T20:48:24+00:00

    Hi Bulletough85

    From the logic you are using in your formula probably you might have some extra characters in your 2nd ZIP codes list 

    so use TRIM function to eliminate them

    =IFERROR(VLOOKUP(TRIM(G9),ZIPCOUNTY,3,0),"")

    If after trying this formula still have issues then Post a screenshot of your data or share the workbook

    It will help us to give prompt and right solution. 

    Do let me know if you require any further help on this. Will be glad to help you.

    If this answer would be the solution to your question, Please, share your appreciation by marking it as answered. I would be grateful to you as well.

    Thanks

    Regards

    Jeovany CV

    Was this answer helpful?

    0 comments