Product & Price lists
 

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?

Product & Price lists
 

http://www.contextures.com/xlFunctions02.html

--


Regards,


Peo Sjoblom

"Aimee UMS" wrote in message
...
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?