Prev: Email Macro
Next: Formula question
From: Dan on 14 May 2010 08:59
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?



From: Jacob Skaria on 14 May 2010 09:06
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?
>
>
>
From: Dave Peterson on 14 May 2010 10:49
I'm not sure where your combobox is, but if you're using one placed on a
worksheet, maybe you could use Data Validation and a formula in another adjacent
cell instead.

Saved from a previous post:

Build a table on a dedicated sheet--in columns A:B.

Then you can use put your entry in A1 (of a different sheet) and use this in the
adjacent cell:

=vlookup(a1,sheet2!a:b,2,false)

Debra Dalgleish has lots of notes:
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://contextures.com/xlFunctions02.html#Trouble

You may even want to make the cell where you put the material have a dropdown
showing you all the options.

Debra Dalgleish has some notes about naming the range:
http://contextures.com/xlDataVal01.html#Name
and using Data|validation on that same page.

Then the formula can change to:

=if(a1="","",vlookup(a1,sheet2!a:b,2,false)

On 05/14/2010 07:59, 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?
>
>
>
 | 
Pages: 1
Prev: Email Macro
Next: Formula question