In an Excel 2010 spreadsheet the user will select the location from the drop box. I need to have the correct post code automatically populate the adjacent cell. for example in cell A1 the user selects Brisbane from the drop box and then the post code i.e. 4000 automatically populates cell B1.
I have created a list with location names in column A and the corresponding post codes in column B. I have used this list to create the locations drop box. What do I do to have the post code populate automatically?