Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do you get a drop down list to equal a value in a separate ce.
im setting up a bid program in excel for our buisness.
in that program i have lists set up so you can pick different products based on the spec. how do i set a value in a separate cell that would display the different cost based on the selection of the item in the list by the user? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do you get a drop down list to equal a value in a separate ce.
have a look at VLOOKUP function.
-- AP "cmh" a écrit dans le message de ... im setting up a bid program in excel for our buisness. in that program i have lists set up so you can pick different products based on the spec. how do i set a value in a separate cell that would display the different cost based on the selection of the item in the list by the user? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do you get a drop down list to equal a value in a separate ce.
create a table of items in column A and costs in column b
Assume the above is in a sheet named Table then assume the item for the bid will be placed in cell B9 of the bid/entry sheet. In cell C9 put in a formula like =if(B9="","",Vlookup(B9,Table!A:B,2,False)) -- Regards, Tom Ogilvy "cmh" wrote in message ... im setting up a bid program in excel for our buisness. in that program i have lists set up so you can pick different products based on the spec. how do i set a value in a separate cell that would display the different cost based on the selection of the item in the list by the user? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
making a drop-down list with two separate columns | Excel Discussion (Misc queries) | |||
Add separate colors to values in drop down list | Excel Discussion (Misc queries) | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
sort list of players by team from player list on separate sheet | Excel Worksheet Functions | |||
Validation Tables For Drop Down list on a Separate Worksheet. | Excel Worksheet Functions |