drop down menu with different price list that reflect on other cells

%3CLINGO-SUB%20id%3D%22lingo-sub-2015322%22%20slang%3D%22en-US%22%3Edrop%20down%20menu%20with%20different%20price%20list%20that%20reflect%20on%20other%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2015322%22%20slang%3D%22en-US%22%3E%3CP%3Ehi%20all%2C%20I%20need%20help%20with%20the%20following%20plz%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20two%20items%2C%20with%20two%20different%20price%20list%20for%20each%2C%20I%20would%20like%20to%20create%20a%20drop%20down%20menu%20with%20the%20pricelist%20of%20each%2C%20so%20when%20I%20choose%20the%20particular%20item%20and%20then%20go%20to%20price%20code%2C%20I%20get%20a%20drop%20down%20menu%20with%20two%20pricelist%2C%20when%20I%20choose%20pricelist1%2C%20automatically%20the%20price%20of%20this%20item%20reflect%20under%20official%20price%3C%2FP%3E%3CP%3Eapply%20the%20below%20%3A%3C%2FP%3E%3CP%3Ein%20the%20item%20list%20when%20I%20choose%20the%20product%20(%20rice%20or%20lemon%20)%3C%2FP%3E%3CP%3Erice%20-%20under%20price%20code%3A%20(drop%20down%20menu%20)%20pricelist1%2C%20pricelist2%20%26gt%3B%26gt%3B%26gt%3B%26gt%3B%20%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20the%20price%20of%20rice%20should%20reflect%20in%20the%20official%20price%3C%2FP%3E%3CP%3Elemon%20-%20under%20price%20code%20%3A%20(drop%20down%20menu%20)%20pricelist1%2C%20pricelist2%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%26gt%3B%26gt%3B%26gt%3B%26gt%3B%20%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20the%20price%20of%20lemon%20should%20reflect%20in%20the%20official%20price%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ehow%20can%20I%20do%20that%20%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2015322%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2016003%22%20slang%3D%22en-US%22%3ERe%3A%20drop%20down%20menu%20with%20different%20price%20list%20that%20reflect%20on%20other%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2016003%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F911569%22%20target%3D%22_blank%22%3E%40bisho0o%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere's%20a%20demo%20file%20I%20created%20for%20somebody%20else%20with%20a%20similar%20question.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

hi all, I need help with the following plz

 

I have two items, with two different price list for each, I would like to create a drop down menu with the pricelist of each, so when I choose the particular item and then go to price code, I get a drop down menu with two pricelist, when I choose pricelist1, automatically the price of this item reflect under official price

apply the below :

in the item list when I choose the product ( rice or lemon )

rice - under price code: (drop down menu ) pricelist1, pricelist2 >>>>      the price of rice should reflect in the official price

lemon - under price code : (drop down menu ) pricelist1, pricelist2            >>>>      the price of lemon should reflect in the official price

 

how can I do that ?

1 Reply

@bisho0o 

 

Here's a demo file I created for somebody else with a similar question. The methods it uses, to create drop down (data validation) lists that change based on a prior selection from a prior drop down, can readily be deployed in your situation. They DO take advantage of Dynamic Array functions that are only available in the newest releases of Excel.