COMBO BOX CALCULATION !

[Guest]

Hi

I need some one help.....

Colum 1: Item Name Colum 2: Price List
A1 B1
A2 B2
A3 B3

so on......

I insert 2 combo boxes. Box 1 (property, input range A1........A20)
cell link
F1

Box 2 (property, input range B1........B20)
cell link
F1
I open box 1 (A1) than box 2 automatically appear (B1) (price)
I will put number in C1 than I would like to get answer [box 2 price (B1) *
C1] in D1.

I hope you will clear my answer, kindly reply my answer ASAP.

Yours kindness would be appreciated.

Many thanks

JOHN

 

[Guest]

in D1:

=C1*INDIRECT("B" & F1)

You have F1 as link cell in both cases ...is this correct?

HTH

 

[Dave Peterson]

I don't think you should use two comboboxes. The second one should never be
used--it'll only be displayed to the user.

In fact, I think it would be much easier to drop the comboboxes and use
Data|Validation for just the cells that will contain the item name.

Then use a formula in column B:
=if(a1="","",vlookup(sheet2!a:b,2,false))

and in d1:
=if(a1="","",b1*c1)

You can find lots of tips for Data|Validation at Debra Dalgleish's site:
http://www.contextures.com/xlDataVal01.html

Hi

I need some one help.....

Colum 1: Item Name Colum 2: Price List
A1 B1
A2 B2
A3 B3

so on......

I insert 2 combo boxes. Box 1 (property, input range A1........A20)
cell link
F1

Box 2 (property, input range B1........B20)
cell link
F1
I open box 1 (A1) than box 2 automatically appear (B1) (price)
I will put number in C1 than I would like to get answer [box 2 price (B1) *
C1] in D1.

I hope you will clear my answer, kindly reply my answer ASAP.

Yours kindness would be appreciated.

Many thanks

JOHN

 

[Guest]

Yes F1 as link cell, I try to type in = C1*INDIRECT("B" & F1) but dosen't
work. I would like to send the excel attach file to let you see than you may
give better advice. If possible could give your e-mail address and your help
would be greatly appreciated.

JOHN

in D1:

=C1*INDIRECT("B" & F1)

You have F1 as link cell in both cases ...is this correct?

HTH

Hi

I need some one help.....

Colum 1: Item Name Colum 2: Price List
A1 B1
A2 B2
A3 B3

so on......

I insert 2 combo boxes. Box 1 (property, input range A1........A20)
cell link
F1

Box 2 (property, input range B1........B20)
cell link
F1
I open box 1 (A1) than box 2 automatically appear (B1) (price)
I will put number in C1 than I would like to get answer [box 2 price (B1) *
C1] in D1.

I hope you will clear my answer, kindly reply my answer ASAP.

Yours kindness would be appreciated.

Many thanks

JOHN

 

[Guest]

Thanks Dave, but I would like to send my excel worksheet to you and you could
give better advice. If possible, may i have your e-mail address and i will
send the attached file for your information. Yours kind advice would be
appreciated.

JOHN

I don't think you should use two comboboxes. The second one should never be
used--it'll only be displayed to the user.

In fact, I think it would be much easier to drop the comboboxes and use
Data|Validation for just the cells that will contain the item name.

Then use a formula in column B:
=if(a1="","",vlookup(sheet2!a:b,2,false))

and in d1:
=if(a1="","",b1*c1)

You can find lots of tips for Data|Validation at Debra Dalgleish's site:
http://www.contextures.com/xlDataVal01.html

Hi

I need some one help.....

Colum 1: Item Name Colum 2: Price List
A1 B1
A2 B2
A3 B3

so on......

I insert 2 combo boxes. Box 1 (property, input range A1........A20)
cell link
F1

Box 2 (property, input range B1........B20)
cell link
F1
I open box 1 (A1) than box 2 automatically appear (B1) (price)
I will put number in C1 than I would like to get answer [box 2 price (B1) *
C1] in D1.

I hope you will clear my answer, kindly reply my answer ASAP.

Yours kindness would be appreciated.

Many thanks

JOHN

 

[Guest]

Hi Dave

I go in to your web and found out what I want it, anyway thanks alot for
your information.

JOHN

I don't think you should use two comboboxes. The second one should never be
used--it'll only be displayed to the user.

In fact, I think it would be much easier to drop the comboboxes and use
Data|Validation for just the cells that will contain the item name.

Then use a formula in column B:
=if(a1="","",vlookup(sheet2!a:b,2,false))

and in d1:
=if(a1="","",b1*c1)

You can find lots of tips for Data|Validation at Debra Dalgleish's site:
http://www.contextures.com/xlDataVal01.html

Hi

I need some one help.....

Colum 1: Item Name Colum 2: Price List
A1 B1
A2 B2
A3 B3

so on......

I insert 2 combo boxes. Box 1 (property, input range A1........A20)
cell link
F1

Box 2 (property, input range B1........B20)
cell link
F1
I open box 1 (A1) than box 2 automatically appear (B1) (price)
I will put number in C1 than I would like to get answer [box 2 price (B1) *
C1] in D1.

I hope you will clear my answer, kindly reply my answer ASAP.

Yours kindness would be appreciated.

Many thanks

JOHN

 

[Dave Peterson]

Glad you found what you needed at Debra's site.

But I've found it best to just post followups directly to the newsgroups. There
are lots and lots of people who can answer your question--and you won't have to
wait for me to read my email.

Hi Dave

I go in to your web and found out what I want it, anyway thanks alot for
your information.

JOHN

I don't think you should use two comboboxes. The second one should never be
used--it'll only be displayed to the user.

In fact, I think it would be much easier to drop the comboboxes and use
Data|Validation for just the cells that will contain the item name.

Then use a formula in column B:
=if(a1="","",vlookup(sheet2!a:b,2,false))

and in d1:
=if(a1="","",b1*c1)

You can find lots of tips for Data|Validation at Debra Dalgleish's site:
http://www.contextures.com/xlDataVal01.html

Hi

I need some one help.....

Colum 1: Item Name Colum 2: Price List
A1 B1
A2 B2
A3 B3

so on......

I insert 2 combo boxes. Box 1 (property, input range A1........A20)
cell link
F1

Box 2 (property, input range B1........B20)
cell link
F1
I open box 1 (A1) than box 2 automatically appear (B1) (price)
I will put number in C1 than I would like to get answer [box 2 price (B1) *
C1] in D1.

I hope you will clear my answer, kindly reply my answer ASAP.

Yours kindness would be appreciated.

Many thanks

JOHN