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