|Read the Excel help files on VLOOKUP and see if that fits your needs.|
You would set up a 2 column table with the list of options from the drop down in the first column and the corresponding value (e.g. £0.46) in the second column.
You would then use VLOOKUP to look up the value chosen in the drop down and return its corresponding value.
The first column of that table could (should) be the same list that populates the drop down to ensure an exact match.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.