Excel - ZIP code range

Question

I have a list of zip codes, being the initial and final track that will determine the location, I named the A column as "ONE" and the B column as "TWO", and I made a PROCV + SE +E, that is if the zip code sought was larger than the ONE interval and smaller than the TWO, it would necessarily return the value of the column of ONE and would make the Proc with the locality, but it did not work, someone can help me please?

Answer 1

How are you?

First, it should be noted that the way you tried to perform this search would not work this way with PROCV, because this formula searches for keys (value sought) exactly equal to the value reported, so it did not work.

So what I did was a gambiarra, but that can help: as the condition to return the correct state is that the ZIP code reported by the user is greater than or equal to the ZIP code of the first track and less than or equal to the ZIP code of the second track, I created an additional column, in which the validation and concatenation of these two conditions is made, thus:

Thus, PROCV looks for the corresponding cells where the value sought is "TRUE".

I tested with four different ceps and it worked.

I’ll leave the spreadsheet in the comments for you to test.

Any problems, let me know.