i am trying to use a formula that accepts equates words to a cost
 

an example of this is Southport = area one and is equal to $5
brisbane is area two and equals $3 i have workd this out for on area but the
trick here is the area times the cost, times items. Only way i have figured
out to do this it equates wrong as it is timing the area code by items ie:
area 1 times 5 items he $5. but if i use area two it does 2 times the items
which gives $6.

Any help will be fgreatly appreciated