trying to construct price list that generates from database

I am trying to create a price list such that when two identical cells turn up the price that is attached in the databse will generate. For example, say part of the price list looks like this
A..............B.................C
1 Town1.....Town2.....$5
2 Town5.....Town3.....$8

In the actual application, when one of those two scenarios were to happen I want column C to generate by itself. For instance,
A.............B.............C
Town5......Town3.....?-->this would remain blank

looking for macro or something that would be able to generate column c using the pre-established price list. Ultimately I would want a subtotal to generate as well. Please let me know if you can be any help or advice. Thanks!

You want the $8 to show up or blank? Not clear.

If the $8, then

=Sumproduct(--('Price List'!A1:A100=A2),--('Price List'!B1:B100=B2),C1:C100)

where Price List sheet, cells A1:C100 contain your pricelist and A2, B2 contain search criteria, respectively