I am using Excel 2007 and I am trying to put together a freight comparison chart and need to add the postcodes for a state so that when I enter the postcode in a cell the suburb, state and freight rate appears in their own cells.
Is this possible?
I am a bit of a noob to playing with Excel and have all these ideas, just not sure how to implement them.
I have attached a copy of the spreadsheets to work with and would appreciate any help. The postcode will be entered in column 'D' and the Suburb and state will be in 'B & C' The rates are in Column 'I'. The rates will be taken from Column D' in the Australian Postcodes sheet.