Hi,

I need to add a state in a separate column in a sheet I am dealing with at the moment and need a formula that will add a state bases on the post code (zip code for those in the US

The postcodes are as follows:
Australian Capital Territory (ACT) 2600 to 2618 and 29##
New South Wales (NSW) 2###
Northern Territory (NT) 08## and 09##
Queensland (QLD) 4###
South Australia (SA) 5###
Tasmania (TAS) 7###
Victoria (VIC) 3###
Western Australia (WA) 6###

I have added a speadsheet which shows what I am working with.loc list.xlsx