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?

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?

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?