Vlookup Formula Needed, Help Please

I am after a vlookup formula, or any formula, that does the following:
When a product is selected in the combo box, the corresponding price that goes with that producr is shown in the next cell.

EXAMPLE:
I select cheese in the combo box, then in the next cell the price 2.48 appears.


I have 8 different products each with its own price, is it possible??


(PS there is a sheet with just data in my document.)

Originally Posted by curly88

I am after a vlookup formula, or any formula, that does the following:
When a product is selected in the combo box, the corresponding price that goes with that producr is shown in the next cell.

EXAMPLE:
I select cheese in the combo box, then in the next cell the price 2.48 appears.


I have 8 different products each with its own price, is it possible??


(PS there is a sheet with just data in my document.)

Not 'Cheese', but will 'Boots' suffice?

In a remote area of your spreadsheet make a lookup table

cheese...............2.48
ham...................1.95

(make sure the products are in ascending alphabetical order)

Highlight it, call it pricetable

Now say your combo box is in A1

In A2 put the formula =vlookup(a1,pricetable,2)