Drop-down Menus

[master_lain]

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

[Paul B]

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" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>