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 $y.yy..........help!

See More: assign value to text(name)

Report •

#1
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:

=VLOOKUP(B6,$O$1:$P$7,2,0)

See the Excel Help files on VLOOKUP for more information.



Report •
Related Solutions


Ask Question