I am have a price list on a worksheet and then I have a statement. On the
statement I have a drop down list of all the products that they can select
from, but I want it to automatically popluate the price of that product in
the next column after they have selected the product. How do I do that?