I want to assign a dollar value to the text cells in the drop down menu
I inserted into my spreadsheet. Each drop down selection will have a
corresponding $ amount so the final price formula can be automatically
calculated.

Hardwood floors = $5.00
Carpet = $2.00

I've tried to find the info on-line but I'm a little lost. Sorry if
this is a simple question.


+-------------------------------------------------------------------+
+-------------------------------------------------------------------+



--
HomeAppreciators

HomeAppreciators;950723 Wrote:
> I want to assign a dollar value to the text cells in the drop down menu
> I inserted into my spreadsheet. Each drop down selection will have a
> corresponding $ amount so the final price formula can be automatically
> calculated.
>
> Hardwood floors = $5.00
> Carpet = $2.00
>
> I've tried to find the info on-line but I'm a little lost. Sorry if
> this is a simple question.


Hi by using a simple drop down box, you can do this.
step 1: right click on drop down box, choose format control
step 2: click on CONTROL
step 3: Define Input range
step 4: Cell link (this is flag indicator)

Please refer to sample spreadsheet that attached with your example

Thanks
bALA


+-------------------------------------------------------------------+
|Filename: Example.zip |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=136|
+-------------------------------------------------------------------+



--
bala_vb

See help on VLOOKUP.


Gord Dibben MS Excel MVP

On Mon, 3 May 2010 14:51:48 +0100, HomeAppreciators
<(E-Mail Removed)> wrote:

>
>I want to assign a dollar value to the text cells in the drop down menu
>I inserted into my spreadsheet. Each drop down selection will have a
>corresponding $ amount so the final price formula can be automatically
>calculated.
>
>Hardwood floors = $5.00
>Carpet = $2.00
>
>I've tried to find the info on-line but I'm a little lost. Sorry if
>this is a simple question.
>
>
>+-------------------------------------------------------------------+
>+-------------------------------------------------------------------+