Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I tie prices to a drop down list of products in excel?
How do I tie prices to a drop down list of products in excel? I have a column
of products that I turned into a drop down box and I have a column of prices that I want to fill in when I select an item from the drop down list. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I tie prices to a drop down list of products in excel?
Assuming that the prices are precede by the product in the form of a lookup
table, you can use VLOOKUP =VLOOKUP(A1,$M$1:$N$20,2,False) where A1 is the DV cell, M1:N20 is the lookup table -- HTH RP (remove nothere from the email address if mailing direct) "trspds" wrote in message ... How do I tie prices to a drop down list of products in excel? I have a column of products that I turned into a drop down box and I have a column of prices that I want to fill in when I select an item from the drop down list. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I tie prices to a drop down list of products in excel?
You can use a Lookup table and VLOOKUP formula.
Assumptions......... You have products in A1:A12 You have prices in B1:B12 In C1 you have your DV drop-down with the products list. In D1 enter =VLOOKUP(C1,A1:B12,2,FALSE) Gord Dibben Excel MVP On Fri, 2 Dec 2005 10:45:03 -0800, trspds wrote: How do I tie prices to a drop down list of products in excel? I have a column of products that I turned into a drop down box and I have a column of prices that I want to fill in when I select an item from the drop down list. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
drop down list in Excel | Excel Worksheet Functions | |||
Excel Question: Can I add images to a drop down list box? | New Users to Excel | |||
How do I choose from the drop down list in excel | Excel Discussion (Misc queries) | |||
Update Excel Data List for Drop Down use | Excel Discussion (Misc queries) | |||
How do I increase type size in an Excel drop down list? | Excel Discussion (Misc queries) |