Help for multiple & variable validation function
 

I have a product database in sheet 1 like as follows:-
A B C
1 Product Pack Price
2 Mango Jam 500 g 35.00 to be continued in various pack
size & price
3 Mango Pickle 150 g 15.00 to be continued in various pack
size & price
4 Pinapple Jam 250 g 25.00 to be continued in various pack
size & price
5 Orange Squash 500 g 40.00 to be continued in various pack
size & price
continued ... end of product list
I have created some reference name according product, pack, & rate, like
Product_data, Mango_Pack, Mango_Rate, Orange_Pack, Orang_Rate etc.
I have made validation list in A2,B2,C2 of sheet 2. Now I want if I select
any product from drop down list in A2 then when click for choose pack size in
B2 it should show related pack size of the selected product in A2, same in C2
(price) also. Is there any solution of the above problem. Plase help me &
thanks in advance.

Help for multiple & variable validation function
 

See if this helps:

http://contextures.com/xlDataVal02.html

--
Biff
Microsoft Excel MVP


"Montu" wrote in message
...
I have a product database in sheet 1 like as follows:-
A B C
1 Product Pack Price
2 Mango Jam 500 g 35.00 to be continued in various pack
size & price
3 Mango Pickle 150 g 15.00 to be continued in various pack
size & price
4 Pinapple Jam 250 g 25.00 to be continued in various pack
size & price
5 Orange Squash 500 g 40.00 to be continued in various pack
size & price
continued ... end of product list
I have created some reference name according product, pack, & rate, like
Product_data, Mango_Pack, Mango_Rate, Orange_Pack, Orang_Rate etc.
I have made validation list in A2,B2,C2 of sheet 2. Now I want if I select
any product from drop down list in A2 then when click for choose pack size
in
B2 it should show related pack size of the selected product in A2, same in
C2
(price) also. Is there any solution of the above problem. Plase help me &
thanks in advance.