Drop Down Boxes
 

Want to put items in drop down box & when select item have the cost come up.
Can create the item box but don't know how to create the cost dropdown box

Drop Down Boxes
 

See help on VLOOKUP

You will need a table with items in one column and costs for items in
another column.

=VLOOKUP(A1,$F$1:$G$20,2,FALSE) entered in B1

A1 is your dropdown cell.

F is your items

G is your costs.


Gord Dibben MS Excel MVP

On Fri, 11 Dec 2009 09:35:01 -0800, Drop Down Boxes <Drop Down
wrote:

Want to put items in drop down box & when select item have the cost come up.
Can create the item box but don't know how to create the cost dropdown box