Determine state via postcode (zip code)

Hi slinkyfox,

First, you codes in D are in text format which can create issues in calculation.
Then, I would suggest you to have a table of postcodes on right side of data and then you can do lookups from there.

let me know if this sounds interesting and if yes, get back with postcodes table and mention some results expected in column E. thanks.

Regards,
DILIPandey
<click on below * if this helps>

For example, postcodes for the state Queensland always begin in 4

and now one will go to column D "Post Code" and will search any post code beginning with 4 and will write State "Queensland (QLD)" as a result in column E.. correct ?

and now he will come again here (in excelforum thread) to proceed with other states.. and hence I suggested to move this table in Excel workbook.. hope this becomes clear now.

Also, if your text numbers (or post codes) can become number then that will help in searching / matching and hence I pointed that your codes are in text format.

Regards,
DILIPandey
<click on below * if this helps>

I'm not to clear as to where you are going with this.

Your data might be best sorted by *Country Code"

I have generated a list of "Unique Codes", Column K, this is used for a Dynamic Name "Unique_Codes", and is in turn used for the Data Validation List in G1.
Select from the drop-down to see the changes in Columns G:I

We can drill further down once you clarify your criteria, then use the new list as a lookup for your codes.

Your Data has many duplicates, these might best be deleted.

This workbook might not provide the answer you are asking for, but it should go some way towards a final solution.

Okay see if this is more like it.

Enter the first digit of the code, as a number, that you want to search for in Gell G1
This can be easily changed to work for the first few digits entered.