Excel drop-down boxes

[T1junkie]

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,
T1

 

[Osiris]

Im wondering if it would be easier to do this is VB

 

[T1junkie]

I found the solution.

I have 2 ranges defined

"Item" Which is the Column that defines the different part Numbers
"ItemTable" Which contains the Item Column and the Column that contains the respective costs.

in Cell C17 I have a DropDown List that loads from "Labor"

in cell E17 I have the forumla =VLOOKUP(INDIRECT("C17"),ItemTable,2,FALSE)

the resources I used where
http://techonthenet.com/excel//formulas/indirect.php
and
http://techonthenet.com/excel//formulas/vlookup.php

I haven't done any error catching so if I select an invalid value in C17 it returns an error

Resolved...