Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 625
  • Last Modified:

Microsoft Excel 2013 VLOOKUP Return Error From Lookup Sheet Duplicate Values

I have a file list of about 200 prospective clients which I've gathered all contact info, minus the state for each unique prospect (Did not have a state column at all during initial contact information gathering; now decided we do need the state). In the midst of attempting to avoid any notable time spent manually adding the states via typing them in, I found an excel file that provides a comprehensive zip code-state listing, where I had hoped to link a VLOOKUP formula in my state column. In using this list (the V-lookup uses the already-known prospect zip code column), I realized that I was getting #N/A returns. This is likely due to the fact that excel does not like your lookup columns to have duplicate values. Is there any short way of fixing this, or a somewhat simple workaround? I have two screenshots, and attached the .xlsx file in reference. Thanks for any help in advance.
excel.png
excel-1.png
REVISED-LEAD-list.xlsx
0
Lee Richardson
Asked:
Lee Richardson
1 Solution
 
Ejgil HedegaardCommented:
You zip codes on sheet Revised are a mix of text and numbers from different sheets (and some are typed), and likewise on sheet State where some are text and some are numbers.

Changes all zip codes on sheet State to be numbers, and changed the formula in column L to look for numbers.
REVISED-LEAD-list.xlsx
0
 
Lee RichardsonOwner & PresidentAuthor Commented:
Well done. Thank you, very much!
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now