I have created multiple defined lists for the user to pick. I want to be
able to calculate that based on selecting the combination of choices, it will
return a dollar value. I don't know if that makes sense to those of you
reading this, but here's a little more detail.

(Each column has a drop down list derived from another worksheet in the
workbook)
Column1 Column2 Column3 Column4 Value
Choice1 Choice1 Choice1 Choice1 *Need it return
a $*
Choice2 Choice2 Choice2 Choice2 ""
Choice3 Choice3 Choice3 Choice3 ""

Basically, I want to calculate the 4 text columns, that depending on the
combination of choices picked, it would return a specific value for that
combination. Does this make any sense. Someone please help!!