Append 788 postcodes to suburbs which may be misspelt or incorrect

Budget $10-$20. Lowest bid will be taken!

Have a simple project where I need someone to search for each address suburb and state in google and then find the correct suburb spelling and the correct postcode.

Steps:

1. Copy cells Address, Suburb, State into google.

2. See what the correct Suburb should be and then do a follow up search for the suburb in sheet 'Lookup'. Then copy the same Suburb, State, Post Code from this sheet back into sheet 'sheet1'

Notes:

• we are only looking for postcode for STREET addresses and not mailing addresses such Po Box or Private Bag etc. In Lookup sheet check the 'Type' to ensure it is Street Type.

• There are duplicate suburb and state however this does not always mean you can use the same suburb and postcode- check each.

• See attached for input file

• Any which you cannot match leave empty- do not guess or add any which may be different.

BPO Εισαγωγή Δεδομένων Διαδικτυακή Αναζήτηση

Ταυτότητα Εργασίας: #5457954

Σχετικά με την εργασία