|What you want can be done using a =VLOOKUP() function.|
First create a worksheet list of your Suburbs with there related amounts, I have named my sheet Suburbs:
1) Colyton $24.71
2) Manly $44.10
3) Alpha $10.00
4) Beta $11.00
5) Gamma $12.00
continue down 100 rows.
On a new sheet, which I've name Master,
in column A cell 1 I put the heading: Suburb Name
in column B cell 1 I put the heading: Amount
In column B cell 2 enter the formula:
When you enter a suburb name into cell A2,
the formula will lookup that name in the Suburbs sheet,
and return the amount indicated.
You can take the formula and drag it down as many rows as necessary.