Drop Down Boxes

D

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
 
G

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

Similar Threads

Creating a Graph from a Drop Down List in Excel 2
Drop Down Box problem 4
Excel 2003 Drop Down Box 2
drop down box issues 1
Drop Down List & Auto Fill 2
Drop down menu formatting 2
Excel drop-down values versus labels 1
making a drop down box 1

Top