Convert Postal Code To County?

[manz77]

Does anyone know a formula that can convert a postal code to the county that it correlates to?

[BenjieLop]

Does anyone know a formula that can convert a postal code to the county that it correlates to?

First of all, there should be a table constucted where the first column contains the "Postal Codes" and the second column has "County" that corresponds to the Postal Codes. For this exercise, let us assume that Column X has the "Postal Codes" while Column Y has the "County" corresponding to the Postal Codes.

If you want to enter the Postal Code in Cell A1 and have Cell B1 give you the corresponding county, here is your formula (enter in Cell B1):

=vlookup(A1,$X$1:$Y$500,2,0)

You can always adjust the range $X$1:$Y$500 to fit your requirements.

Hope this will help you.