|I would use VLOOKUP.|
With your Drop Down in A1, your formula in B1 would look something like this:
=VLOOKUP(A1, $C$1:$D$10, 2, 0)
Where C1:C10 contains the items that populate the Drop Down and D1:D10 contains the price for each item.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.