Excel Function To Populate Cells

June 18, 2011 at 18:02:57
Specs: Windows XP
I need to find out how to assign a text a numerical value
e.g. 4/4" Poplar = $1.50

I am trying to create a drop down menu of items that represent variuos values

See More: Excel Function To Populate Cells

Report •

June 19, 2011 at 06:02:23
I would use VLOOKUP.

With your Drop Down in A1, your formula in B1 would look something like this:

=VLOOKUP(A1, $C$1:$D$10, 2, 0)

Where C1:C10 contains the items that populate the Drop Down and D1:D10 contains the price for each item.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question