Check Postcode and suburb

  • Thread starter Thread starter Goldie
  • Start date Start date
G

Goldie

l have a spreadsheet that has lots of postcodes with suburbs, l need to check
they are correct using the post offices post code with suburb.

is there a program l can run to do this

Thx in advance
 
Australian Postcode?
With these, you get a different localities with the same postcode and
different postcodes for the same locality.

Can you add a column to your Postcodes workbook and sort it ascending? If
so, you can use Match():

Create a combined PostcodeLocality column and sort by this. Then back in
your sheet that requires checking

=MATCH(A1&B1,'pc-book_20090630.csv'!$K:$K,0)

A1 above is postcode, B1 is locality, column K in pc-book_20090630.csv is
the combined Postcode Locality.

The result returns a row number or #N/A (if not exists).
 
works like a treat thanks heaps

AltaEgo said:
Australian Postcode?
With these, you get a different localities with the same postcode and
different postcodes for the same locality.

Can you add a column to your Postcodes workbook and sort it ascending? If
so, you can use Match():

Create a combined PostcodeLocality column and sort by this. Then back in
your sheet that requires checking

=MATCH(A1&B1,'pc-book_20090630.csv'!$K:$K,0)

A1 above is postcode, B1 is locality, column K in pc-book_20090630.csv is
the combined Postcode Locality.

The result returns a row number or #N/A (if not exists).
Click to expand...
 
Back
Top