DPChristman
Board Regular
- Joined
- Sep 4, 2012
- Messages
- 177
- Office Version
- 365
- Platform
- Windows
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?
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?
