Check out help on VLOOKUP()


--
Jacob (MVP - Excel)


"Dan" wrote:

Hi everyone

Hopefully somone can help me with my combo box problem. I am not any expert
in Excel so please keep any answer as simple as possible ;)

I want to use Combo box for budget matters. For example if i have a list of
different items such as:

A1 A2
Gloves 1$
Bananas 10$
Car 45$

If i choose banana from the combo box, the output value in the budget
becomes 2.

So the obvious question is. How do i make excel choose the values in A2
instead?