okie i need help in this.am stuck at this point.

i have a database of product and price

of which

i have included the product in a dropdown list in another worksheet,

what i would want to do is that when i select the product from the dropdown list, the price will appear.

can anyone teach me how to go abt doing it?