Build a simple lookup table somewhere in the sheet. Then next to the
cell with the drop down put a lookup formula such as =VLOOKUP(Name,
NameCost_Table, 2,FALSE).

That should get you started.

- John