Find state by city name

[deepakl]

Hey friends,
Can someone help me to create a sheet where I can get the State name by entering city name.
For eg; When I put Barwon Downs(city) in column A, column B should reflect Victoria (state). Attached is the sheet with data.

 

[etaf]

you can setup a reference sheet , with all the city names and states
chances are this list already exists on the internet
so you can use with a lookup

=vlookup()

what country did you need to cover , australia

this may help create the lookup table
List of towns in Australia - Wikipedia
list of cities and towns in Australia | Australia | Britannica.com