Check Postcode and suburb
 

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

Check Postcode and suburb
 

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).



--
Steve

"Goldie" wrote in message
...
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

Check Postcode and suburb
 

works like a treat thanks heaps

"AltaEgo" wrote:

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).



--
Steve

"Goldie" wrote in message
...
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