I am trying to make a spreadsheet to allow for pricing. I have a dropdown box
in a cell with stock codes and I want to attach a cost to each code so I only
have to click on the code for it to be included in a formula. How can I have
the formula read a number(cost) from a text(stock code) cell?