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



--
Steve

"Goldie" <(E-Mail Removed)> wrote in message
news:B0893587-0559-40DC-A2BB-(E-Mail Removed)...
> 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
>

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" <(E-Mail Removed)> wrote in message
> news:B0893587-0559-40DC-A2BB-(E-Mail Removed)...
> > 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
> >
>