Hi

I have created a drop down list of products in sheet2 A2:A32 and prices in
B2:B32 and have a product list nicely apearing in my main sheet BUT not the
prices too

What i really want is to also have the prices apear in the next column when
i select a product

Any ideas and is this possible