vlookup formula to get price when product is selected

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!!

Don't know if I'm understanding you but;

=VLOOKUP(product,A20:B25,2,FALSE)

I renamed cell A1 to "product" then A20;A25 as "cheese" etc and B20:B25 as the prices.

The above formula sits in cell A2 and displays the price found in B20:B25

Is this what you're looking for?

Cheers

Tony

THANKS YOU CHAMPION!!!

I figured it out and left work early, to reward myself, so thanks a lot