Multiple Matches Coding Problem [Excel 2010/14, VBA Only]

I have the code below. I am having difficulty on figuring out how to code VBA to trigger a 2nd vlookup (or match, something) if there are multiple results for the initial vlookup(). Which as I am typing this I am realizing that I need to use a different function as vlookup only retrieves the first match.

Please Login or Register  to view this content.

Alas, the code did not work correctly. It returns "IL01" no matter what the geozip is.
I am playing with the following code (as well as moving the GEOZIP to Col B from Col D) to setup a range for a 2nd vlookup

Please Login or Register  to view this content.

Originally Posted by lloydgodin

Alas, the code did not work correctly. It returns "IL01" no matter what the geozip is.
I am playing with the following code (as well as moving the GEOZIP to Col B from Col D) to setup a range for a 2nd vlookup

It worked for me using your example File.

I downloaded the example file and used your code. It still is returning IL01 every time.
Oh yea, that's because my example is bad. It's IL01 for both zipcodes for (forest park)... I'm a fktard.
Let me check with another city....

It's working!!!

Alternatively, you could have a column on the Data sheet that is a City&GeoZip combo e.g.
GLENVIEW622

Then do a VLOOKUP on that column and look for the City&Geozip combo.

OK so it's not working correctly.

For example, if I enter WAUKEGAN as the city and the patient zipcode as 60085 I am getting the "Zipcode is not found in IL" message.

Please Login or Register  to view this content.

should only be used if the patient city has 2+ results.

I uploaded a new file with the complete dataset.

Changed the code as follows. It works. Not sure what potential errors may/may not occur...

Please Login or Register  to view this content.