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?