Hi,
I have a spreadsheet with various columns of data and one of those is the suburb of the client. The next column is for the Postcode (also known as ZIPCODE in the US).
I'm after a formula that will read the Suburb in Column J and automatically insert the correct Postcode in Column K. I already have a lookup table of postcodes in another worksheet (within the same workbook).
Anyone have any ideas? Thanks in anticipation.
Bookmarks