OK, a really tricky one now for Excel gurus!

  • Thread starter Thread starter tim :/
  • Start date Start date
T

tim :/

A perfect response before, this time a little trickier!

I have two data sources:

Data A) a column of approx. 3000 cells featuring the 'Post Code' only from a
database of addresses.
Data B) The Australian postcode database as found and downloaded from the
below link:

http://www1.auspost.com.au/postcodes/index.asp?sub=2

What I want to happen is each postcode from source 'A' to match up with the
corresponding post code from source 'B' (this is in column A). Once it
matches, the 'Delivery Office' (column E) is to appear in column B of Data
Source Sheet A....I can then sort my data by delivery office...

I hope that makes sense!!

Many thanks
Tim.
 
Simple VLOOKUP

=VLOOKUP(A1,'Data B Sheetname'!A1:B3000,2,False)

--

HTH

RP
(remove nothere from the email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do you suppress blank Address lines during a Word merge? 2
Button on Form to find a file to use in query but not import- dbf,text,excel 1
HELP: Macro to conduct web query and return results 1
Comparing contents of two spreadsheets and outputting results to a 5
locking cells in a column to cells in another column 2
Querying for postcodes within an address against another masters t 6
linking fields 1
data to summary sheet for a dummy 0

Back
Top