Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
drop down lists
I haave a drop down list which is in a table. When I change the selection (on
the list) I want another cell in my "price column" to change value with it. Is this possible? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
drop down lists
Hi
You could create a list with values relating to the items in your dropdown list. Set up on Sheet2 in cells A1:B100 a list with Item in A and price in B Supposing your Column with the dropdown is Sheet 1 column A, and your Price column is column C. In C1 =Vlookup(A1,Sheet2!$A$1:$B$100,2,0) -- Regards Roger Govier "Vivek" wrote in message ... I haave a drop down list which is in a table. When I change the selection (on the list) I want another cell in my "price column" to change value with it. Is this possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
drop down lists | New Users to Excel | |||
Drop Down Lists | Excel Worksheet Functions | |||
Drop Down Lists - Not allowing other contents to be put in same ce | Excel Worksheet Functions | |||
Data Validation - Drop down lists - if then? | Excel Discussion (Misc queries) | |||
Can different drop down lists be displayed depending on the value. | Excel Discussion (Misc queries) |