assign value to text(name)

Microsoft Excel 2003 (full product)
April 19, 2010 at 12:29:06
Specs: Windows XP
I need to assign a price for selections in a drop down box. I need to Dollar value to appear in another cell. ex. if the choice selected from the drop down box in cell b6 is (3/4" Oak Ply), cell h6 needs to show $x.xx, if c6 selection is 3/4" birch ply, h6 needs to show $!

See More: assign value to text(name)

Report •

April 19, 2010 at 12:37:59
You can set up a table with your products in the first column and the corresponding price in the second column.

Let's say your table is in O1:P7

           O             P
1    3/4" Oak Ply       $x.xx
2    3/4" Birch Ply     $y.yy
3    etc.

Let's say your drop down is in B6

In H6 use:


See the Excel Help files on VLOOKUP for more information.

Report •
Related Solutions

Ask Question