Results 1 to 2 of 2

Thread: Using VLOOKUP to pull up non-unique responses.
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular DPChristman's Avatar
    Join Date
    Sep 2012
    Posts
    126
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Using VLOOKUP to pull up non-unique responses.

    This is the age old problem where VLOOKUP pulls up #N/A, because you have duplicates of the same data in the lookup range.

    In my case, I have a listing of about 50K employees, and part of my form is for the users to enter the employee ID number, and have the form return all relevant information (Address, DOH, DOB, Phone, Zip Code, etc)

    The problem is the zip code range.

    Unless you are dealing with the ONLY employee to live in a given zip code, you are going to get an #N/A result.

    I thought of using a SUMIF statement to pull up the Zip Code based on the employee number.

    The problem is that the lookup data will not be open when the form is being filled out, so the SUMIF will not work.

    Is there a workaround for this?

  2. #2
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    29,177
    Post Thanks / Like
    Mentioned
    483 Post(s)
    Tagged
    49 Thread(s)

    Default Re: Using VLOOKUP to pull up non-unique responses.

    Why not do the lookup on the employee ID?
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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