Multiple Drop down to select displayed price

[lonnie451]

Hello...

Have a small issue...

I have 2 drop down menus.. one for the product name and the other for the product size.. I am wanting to select the price for the size and brand of a particular product.
I guess what I am looking for is " I select bellow in drop down one and Medium in Drop down 2, the price will be reflected in the proper cell."

All help is appreciated..

 

[julhs]

I may well not be able to help you!!

But you will have to make it clearer what data and where it is that you are working with so maybe someone else can!!

Without seeming to be too harsh; where is the “Product name”, “Size” and corresponding “Price” being linked?

Unless there is some form of link; eg an expanded drop down list to include “Product name” “Size” and “Price” for each one, it can’t just guess as to what the price might be

 

[lonnie451]

I may well not be able to help you!!

But you will have to make it clearer what data and where it is that you are working with so maybe someone else can!!

Without seeming to be too harsh; where is the “Product name”, “Size” and corresponding “Price” being linked?

Unless there is some form of link; eg an expanded drop down list to include “Product name” “Size” and “Price” for each one, it can’t just guess as to what the price might be

I have my Product , sizes and Prices on a separate sheet.
Example, one drop down will have the Product and the second drop down will have the sizes..
Once they are selected, I am looking for the Price cell to reflect the price base upon the selections from both drop downs.

I never take things too harsh, we all have to learn at some point...lol... I keep forgetting to put in more information...

I will post something here in a few..

 

[julhs]

Firstly is it a Forms control or ActiveX drop down?
Secondly, exactly what sort of drop down is it; a Combo box, List box or what ever?

If the Workbook it's in is meant for distribution then ActiveX controls are not what you need to use, majority of systems block ActiveX.
So Forms control are your only option.

I know ActiveX controls have the reputation of being a bit "Flaky" but I use them all the time.
I find they have a lot of functionality in themselves without the need for VBA.

P.S I use ActiveX because my Workbooks are for personal use and not for distribution

 

[lonnie451]

Firstly is it a Forms control or ActiveX drop down?
Secondly, exactly what sort of drop down is it; a Combo box, List box or what ever?

If the Workbook it's in is meant for distribution then ActiveX controls are not what you need to use, majority of systems block ActiveX.
So Forms control are your only option.

I know ActiveX controls have the reputation of being a bit "Flaky" but I use them all the time.
I find they have a lot of functionality in themselves without the need for VBA.

P.S I use ActiveX because my Workbooks are for personal use and not for distribution

well since I have no clue what "ActiveX" is... I just use the list option when validating it. It is meant for distribution, at some point. lol

 

[lonnie451]

When I make my selections in the product and QTY, I am wanting the correct price for the selected items... Right now I have none ...

Book3
	B	C	D	E	F
6		Test
7
8
9	Product	Qty	Description	Price	Total
10	Grapes	1LB
11
12
13
14
15
16
17
Sheet1

Cells with Data Validation
Cell	Allow	Criteria
B10	List	=Sheet2!$A$4:$A$6
C10	List	=Sheet2!$B$3:$D$3

 

[julhs]

What is the 'Description' meant refer to ?
With out a 'Price' in E10 your not going any where.
What is the formula to get the 'Total price'?

We are ALL on a learning curve; I'm only just starting

 

[lonnie451]

What is the 'Description' meant refer to ?
With out a 'Price' in E10 your not going any where.
What is the formula to get the 'Total price'?

We are ALL on a learning curve; I'm only just starting

Pricing is on sheet two...

I created a pricing sheet for my screen printing business, that uses if statements, last year.. I am just expanding on things and want to simplify.. not really simplify but be able to have multiple different products, without having to have several different sheets.

Book3
	A	B	C	D
3	Product	1LB	2LB	3LB
4	Grapes	0.99	1.50	2.25
5	Bananas	0.89	1.45	2.45
6	Pecans	0.60	1.75	4.00
Sheet2

 

[Marcílio_Lobão]

*loonie451, Good morning.

Hi julhs.

You can solve this question using a combination of VLOOUKP and MATCH functions.

Try to use:

Sheet1
E10 --> =VLOOKUP(A10; Sheet2!$A$4:$D$6; MATCH(B10; Sheet2!$A$3:$D$3;0); FALSE)

Please, tell us if it worked for you.

I hope it helps.

 

[julhs]

*lonnie451.

From all the info and the exact LAYOUT that you now provided; this will work to give a “Price” in E10, dependant on the selections made in B10 and C10.

=VLOOKUP(B10,Sheet2!$A$4:$D$7,MATCH(C10,Sheet2!$A$4:$D$4,0),0)

If the you change the layout of either Sheet 1 or Sheet2, then cell references will have to be changed accordingly to reflect the changes