I have made my last query/question easier, as the other one did not get any replies, i have removed the combo box

Now what i wish to achieve is, when a cell has a product in it, the price on another sheet should correspond

example
CHEESE is in the cell of the sheet products,
in the sheet of prices i want the price 2.78 to appear.

Please help, im in desperate need!!