Excel drop-down boxes
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?
IBM/Lenovo T43 2687DSU
Pentium M 2.0Ghz
1024 MB (DDR2 SDRAM)
80 GB Ultra ATA, 5400 RPM
Windows XP Pro
64MB ATI MOBILITY RADEON X300
Integrated 802.11A/B/G, Bluetooth, 10/100/1000 Eth.