Drop Down Boxes


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

Gord Dibben

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question