Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Dro pdown list formulas
I have a table of product and prices and i want to create a drop down list to
select product with a formulae in another cell that returns the relevant retail price dependant on the product selected from the drop down list, with another cell returning the cost price |
#2
|
|||
|
|||
Name Table the 2-column list of products and prices.
Data validate the cells of interest with Allow set to List and Source set to: =INDEX(Table,0,1) Let A2 on some sheet be such a data validated cell. In B2 you can invoke: =VLOOKUP(A2,Table,2,0) to retrieve the price associated with the product selected in A2. richy007 wrote: I have a table of product and prices and i want to create a drop down list to select product with a formulae in another cell that returns the relevant retail price dependant on the product selected from the drop down list, with another cell returning the cost price |
#3
|
|||
|
|||
You can use data validation to create a drop down list. There are
instructions in Excel's Help and he http://www.contextures.com/xlDataVal01.html In adjacent cells, you can use a VLookup formula to return the price from your price list. There's an example he http://www.contextures.com/xlOrderForm01.html richy007 wrote: I have a table of product and prices and i want to create a drop down list to select product with a formulae in another cell that returns the relevant retail price dependant on the product selected from the drop down list, with another cell returning the cost price -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
list 1 has 400 names List 2 has 4000. find manes from list 1 on 2 | Excel Worksheet Functions | |||
Applying formulas only to the subtotals of a data list | Excel Discussion (Misc queries) | |||
find names on list 1 in list 2. list 1 4000 names list 2 400 name | Excel Worksheet Functions | |||
Array Formulas take waaaay too long... | Excel Worksheet Functions | |||
Creating a list from an existing list. | Excel Worksheet Functions |