Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop down boxes/tick boxes | Excel Worksheet Functions | |||
Help With Drop Down Boxes | Excel Discussion (Misc queries) | |||
Drop down boxes | Excel Worksheet Functions | |||
drop down boxes | Excel Discussion (Misc queries) | |||
Drop Down Boxes | Excel Worksheet Functions |