Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop-down Menus
I've been messing around in excel, learning it as I go, as an experiment I started making an Invoice for my Pseudo company, it will have the following fields |Item. Desc. | Part Number | Quantity | Unit | Total | I have created a drop down box for part number that will pull a list of items off my "Items" worksheet, when I select a part number I want it to pull the unit cost for that part number from the cell imediately next to the part number on my "Items" worksheet and put it in the unit cost field. How might I go about this? Thanks, Lain -- master_lain ------------------------------------------------------------------------ master_lain's Profile: http://www.excelforum.com/member.php...o&userid=35027 View this thread: http://www.excelforum.com/showthread...hreadid=547705 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop-down Menus
Lain, have a look at vlookup in help
-- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "master_lain" wrote in message ... I've been messing around in excel, learning it as I go, as an experiment I started making an Invoice for my Pseudo company, it will have the following fields |Item. Desc. | Part Number | Quantity | Unit | Total | I have created a drop down box for part number that will pull a list of items off my "Items" worksheet, when I select a part number I want it to pull the unit cost for that part number from the cell imediately next to the part number on my "Items" worksheet and put it in the unit cost field. How might I go about this? Thanks, Lain -- master_lain ------------------------------------------------------------------------ master_lain's Profile: http://www.excelforum.com/member.php...o&userid=35027 View this thread: http://www.excelforum.com/showthread...hreadid=547705 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
drop down menus | Excel Discussion (Misc queries) | |||
formulas for drop down menus | Excel Discussion (Misc queries) | |||
how do i set up drop down menus to populate cells in excel? | Excel Discussion (Misc queries) | |||
how do I insert drop down menus into excel that are dependent on . | Excel Discussion (Misc queries) | |||
Drop down menus | Excel Discussion (Misc queries) |