Using VLOOKUP to pull up non-unique responses.

DPChristman

Board Regular
Joined
Sep 4, 2012
Messages
126
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?
 

Some videos you may like

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
38,617
Office Version
365
Platform
Windows
Why not do the lookup on the employee ID?
 

Watch MrExcel Video

Forum statistics

Threads
1,095,481
Messages
5,444,736
Members
405,298
Latest member
fxtrtr17

This Week's Hot Topics

Top